Column totals

This feature is a tool for inserting, re-positioning and deleting column totals in stacked bar charts and stacked column charts in both Word, PowerPoint and Excel.

Create and insert column totals

This command inserts a text box above (or below for negative numbers) the stacked column bar series or stacked bar chart series. This text box will hold the sum of all of the data points in the stacked series.

CMD

<Cmd case="BaseExtensions:stacked-chart-totals"/>

Parameters

FontName

Define the font of the inserted text box.

FontSize

Define the font size of the inserted text box.

DistanceValue

Define the offset value from data point to text box, e.g. DistanceValue="4.818898".

Reposition column totals

This command looks at the new data range of the chart and the metadata of the data shape in question and repoistion the shape to fit the new data range. This is handy if the data in the chart changes, as it allows the user to easily ensure that all objects in the chart are pointing to the correct location.

CMD

<Cmd case="BaseExtensions:stacked-chart-totals-reposition-all"/>

Delete column totals

This command removes all column totals in the chart.

CMD

<Cmd case="BaseExtensions:stacked-chart-totals-delete-all"/>