Show or hide total values on a chart

Contents[Hide]

1. Overview

This article explains how to show or hide data points representing total values on a chart.

2. Show total values

For this example, set up a chart to display OrderQty by OrderDate.

By default, the chart uses a Date/Time axis, but this won't work with total values. Go to the toolbar and change it to Category Axis which will give you expanders along the X-axis.

Set up a bar chart
Set up a bar chart

Go to Properties for the chart and look under Main \ OPTIONS. Uncheck the Hide Total Values property which applies to chart types other than Pie. When this property is unchecked, grand totals and subtotals are displayed in the chart.

Specifically, you'll see an (All) data bar added to the chart above which represents the sum of the other data bars. In the Data Preview, the Grand Total value in the table visualization corresponds to this newly added data bar.

Unhide the total values
Unhide the total values

Next, open the Data Binding Panel for the bar chart and drag the Product hierarchy to the COLUMNS field. This will generate a chart series for each Product value plus an additional series which displays the grand total for each row or data point. Also, the (All) value turns into a cluster of total values, each representing the grand total for a specific Product.

Chart now displays grand total row and column values
Chart now displays grand total row and column values

Comparison of values in the above chart may be difficult because the total values are so much larger than the rest. You can improve the situation by hiding the total that is displayed at each cluster. To do this, open the Data Binding Panel for the bar chart and click the Edit button at the top. In the Configure Metric Set Binding dialog, set Shown Totals to Rows.

Edit the metric set and configure the totals it should show
Edit the metric set and configure the totals it should show

The overall total value and the grand total for each row (data point) are not displayed anymore, only the grand total for each Product. This makes it easier to compare values in the chart.

Only totals for each Product are shown
Only totals for each Product are shown

3. Show grand total for a pie chart

Pie charts are handled a bit differently because they already display total values other than grand totals.

For a pie chart, uncheck its Hide Grand Total property in order see the grand total value which is displayed at the center of the chart.

Pie chart showing a grand total
Pie chart showing a grand total

4. See also

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri