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"/>
Comments
0 comments
Article is closed for comments.