Bar Chart Visualization with Excel Power View

Last Updated : 20 May, 2026

Bar Chart Visualization in Excel Power View is a simple and effective way to compare data across different categories using horizontal bars.

  • It helps users quickly understand differences in values and analyze trends across multiple data series.
  • Power View offers Clustered, Stacked, and 100% Stacked bar chart options, making data exploration more interactive and insightful.

Bar Chart Visualization

In this example, countries are shown on the vertical axis and numerical values on the horizontal axis for comparison.

dataset
Create a table in Power View using the fields: Country, Events, and Season.

Steps to Create a Bar Chart Visualization

The following example shows how to create a bar chart in Excel step by step:

Step 1: Create a table in Power View. Choose the Country, Events, and Season options. This Country and Events are category fields, whereas Events are numbers.

creating-table
Create a table in Power View using the fields: Country, Events, and Season.

Step 2: Choose the Table. Select the DESIGN tab. Select Bar Chart from the Switch Visualization group. Any option you can select from the dropdown menu. But here Clustered Bar option is selected.

selecting-design-tab
From the Design tab, choose “Clustered Bar” under Switch Visualization.

Step 3: Assign Events to the Values area, Country to the Axis, and Seasons to the Legend in the Power View Fields pane.

power-view-fields
Assign Events to Values, Country to Axis, and Seasons to Legend in the Power View Fields pane.

Step 4: The table will be transformed into a Clustered Bar chart. A Bar Chart appears with Events by Country and season. The X-Axis represents the events, while the Y-Axis represents the country. The data points are shown as different bars, demonstrating the different seasons.

clustered-bar-chart-created
Clustered Bar Chart generated – Events on X-axis, Countries on Y-axis, colored by Season.

Data Exploration using Bar Chart Visualization

A Bar Chart may be used to analyze data in a variety of ways. You will understand the many data visualization methods accessible to you. Hover your mouse over one of the bars. Then it will display information about the country, season, and event.

message-box-in-bar-chart
Hovering over a bar shows detailed tooltip: Country, Season, and Event values.

Choose the Bar. Only that particular Bar will be highlighted. The remaining Bars will be inactive.

choosing-bar
Clicking a specific bar highlights it while dimming others for focused analysis.

Bar Chart and Table Combination

By adding a Table to the same Power View, you may see the Bar Chart presentation.

bar-chart-and-table-combination
Combining a table with the Bar Chart shows corresponding data for each visualized element.

Choose a country, events, and season. Make the Bar Chart and Table places as shown above. The table displays the values of the data points indicated in the Bar Chart.

Comment

Explore