Column Charts (Report Builder 1.0)
A column chart displays data over a period of time or illustrates comparisons among items. There are three types of column charts: column, stacked column, and 100% stacked column.
Column
A column chart compares values across categories. The series values are displayed as individual columns, grouped by category. The height of each column is determined by the series value.
Chart area |
Description |
|---|---|
Values |
Required. The values in a value series determine the height of the columns in that series. Value labels appear on the y-axis. Each value series appears as individual columns. |
Category groups |
Optional. Categories are displayed as columns or groups of columns on the x-axis. Multiple groups are nested. |
Series groups |
Optional. Series are displayed as individual columns in the chart. Each series is also displayed in the chart legend. |
Stacked Column
A stacked column chart displays the relationship of individual items to the whole, comparing the contributions of each value to a total across categories. The series values are stacked in a single column for each category. The height of each column 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 that series in the column. Value labels appear on the y-axis. Each value series appears as a section within the column. |
Category groups |
Optional. Categories are displayed as columns on the x-axis. Multiple groups are nested. |
Series groups |
Optional. Series are displayed as sections within columns in the chart. Each series also is displayed in the chart legend. |
100% Stacked Column
A 100% stacked column chart compares the percentage each value contributes to a total across categories. This chart type displays all series values stacked in a single column for each category. The height of each column is always the full height of the chart. The series values are displayed as percentages of each column.
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 column. The y-axis shows a value of 0 to 100. Each value series appears as a section within the column. |
Category groups |
Optional. Categories are displayed as columns on the x-axis. Multiple groups are nested. |
Series groups |
Optional. Series are displayed as sections within columns in the chart. Each series also is displayed in the chart legend. |
Hybrid Column/Line Charts
You can also create a chart that combines both columns and lines in a single chart. To do this, you create a column chart with multiple value series, then select the Plot data as line check box in the Format Data Series dialog box on one or more of the value series to display the data series as a line.
Note
To open the Format Data Series dialog box, right click the tab of the item you want to convert, and select the Format Data Series option. In the Format Data Series dialog box, select the Plot data as line check box.