Bar Charts
A bar chart displays series as sets of horizontal bars that are grouped by category. Values are represented by the length of the bars as measured by the x-axis. Category labels are displayed on the y-axis. Bar charts are typically used to compare values between categories.
There are three types of bar charts: bar, stacked bar, and 100% stacked bar.
Bar
A bar chart displays series as individual bar, grouped by category. The width of each bar is determined by the series value.
| Chart area | Description |
|---|---|
Values |
Required. The values in a value series determine the width of the bars in that series. Value labels appear on the x-axis. Each value series appears as individual bars. |
Category groups |
Optional. Categories are displayed as bars or groups of bars on the y-axis. Multiple groups are nested. |
Series groups |
Optional. Series are displayed as individual bars in the chart. Each series is also displayed in the chart legend. |
Stacked Bar
A stacked bar chart displays all series stacked in a single bar for each category. The width of each bar is determined by the total of all series values for the category.
| Chart area | Description |
|---|---|
Values |
Required. The values in a value series determine the size of the of that series in the bar. Value labels appear on the x-axis. Each value series appears as a section within the bar. |
Category groups |
Optional. Categories are displayed as bar on the y-axis. Multiple groups are nested. |
Series groups |
Optional. Series are displayed as sections within bars in the chart. Each series also is displayed in the chart legend. |
100% Stacked Bar
A 100% stacked bar chart displays all series stacked in a single bar for each category. The width of each bar is always the full width of the chart. The series values are displayed as percentages of each bar.
| Chart area | Description |
|---|---|
Values |
Required. The values in a value series are used to determine the percentage of the whole. This percentage determines the size of the series in the bar. The x-axis shows a value of 0 to 100. Each value series appears as a section within the bar. |
Category groups |
Optional. Categories are displayed as bars on the y-axis. Multiple groups are nested. |
Series groups |
Optional. Series are displayed as sections within bars in the chart. Each series also is displayed in the chart legend. |
See Also
Concepts
Working with Chart Data Regions