Data Visualizations in Power View

Last Updated : 20 May, 2026

Data visualization is the process of representing data visually to make it easier to understand and analyze. In Excel, Power View allows users to create interactive reports and charts such as tables, matrices, cards, and graphs.

Note: Power View is deprecated in modern Excel versions and may not be available in Excel 2016 and later. Microsoft recommends using Power BI for advanced data visualization

Types of Data Visualization in Power View

  • Table Visualization
  • Switch Visualization
  • Matrix Visualization
  • Card Visualization
  • Chart Visualization

Let's consider sample data to discuss different types of visualization.

Sample Data

Here you can see we create a dataset with some fields.

Create a dataset
"We’ve prepared a sample dataset containing a few relevant fields for demonstration."

Table Visualization

Table visualization can visualize the data present in the table. We can select the particular columns to represent those data in a table for that follow the further steps:

Step 1: Select the cell from A1 to D7.

Select the cell
Select cells A1 to D7 from your dataset.

Step 2: Select the Insert tab from the ribbon.

Select the Insert tab
Click the Insert tab from the ribbon.

Step 3: Select Power View from the View section.

Select Power View
Select Power View under the View section.

Step 4: A table will be displayed where we can also select columns that we want to visualize from the Power View Fields list.

A table will be displayed where we can also select columns
Choose the desired columns from the Power View Fields pane to display in the table.

Switch Visualization

It helps to visualize the table in different types of visualization and this option is given by Switch Visualization where we can switch from one type of visualization to another. For that follow the further steps:

Step 1: Select the Design tab from the ribbon.

Select the Design tab
Open the Design tab on the ribbon.

Step 2: We will get a section on Switch Visualization where we can choose different types of visualization which we will discuss in this article.

go to the Switch Visualization
Use the Switch Visualization group to change between table, chart, matrix, and other formats.

Matrix Visualization

This visualization is similar as Table Visualization but it can display the values without any repetition and also it can display the totals and subtotals of the columns or rows. For that follow the further steps:

Step 1: Select Table from the Switch Visualization section of the Design tab.

Select Table from the Switch Visualization
In the Design tab, click Table under Switch Visualization.

Step 2: Select Matrix from Table.

Select Matrix from Table.
Select Matrix from the dropdown.

Step 3: A table is displayed where the name of the country is not repeated. Totals and subtotals of the medals have been displayed.

A table is displayed where the name of the country is not repeated.
View data with totals/subtotals and no repeated values in rows or columns.

Card Visualization

It will display the data in the table from each row. It looks like an index card where the count of medals is displayed respectively to their country and sports. For that follow the further steps:

Step 1: Select Table from the Switch Visualization section of the Design tab.

Select Table from the Switch Visualization section
From the Design tab’s Switch Visualization group, select Table.

Step 2: Select Card from Table.

Select Card from Table.
Choose Card from the list.

Step 3: The card visualization table has been displayed.

The card visualization table has been displayed.
Data appears in individual card format for each row entry.

Chart Visualization

Data can be represented in Bar charts, Column charts, Pie charts, Scatter plots and etc. According to our sample data, we will discuss Stacked Column Charts and Pie charts that follow the further steps:

Step 1: Select Column Chart from the Design tab.

Select Column Chart from the Design tab.
In the Design tab, go to Column Chart.

Step 2: Select Stacked Column from the Column Chart section.

Select Stacked Column from the Column Chart section.
Select Stacked Column to visualize grouped data.

Then, we will get a Stacked Column Chart of our data.

get a Stacked Column Chart of our data.
Stacked Column Chart of our data.

Now, follow the further steps to present the data in Pie Chart.

Step 1: Select the Other Chart from the Design tab.

Select the Other Chart
In the Design tab, click Other Chart.

Step 2: Select Pie from the Other Chart section.

Select Pie from the Other Chart section.
Select Pie to convert your data into a pie chart view.

Then, we will get a Pie Chart of our data.

we will get a Pie Chart of our data.
A Pie Chart of our data.
Comment

Explore