The following procedure shows how to display Subtotals as clean, numerical text for each bar in any Strategy Developer stacked bar graph, using the Tutorial project for demonstration purposes.
1. Create a report with 'Year' attribute on rows and 'Category' attribute and 'Revenue' metric on the column as shown below:
2. Run the report and add the Subtotal by going to Data menu -> Grand Totals. The output the report is shown below:
3. Go to the Graph view and select either the 'Vertical Bar: Stacked' or the 'Horizontal Bar: Stacked' graph type. In this example, 'Vertical Bar: Stacked' will be used.
4. Go to Graph menu -> Graph options -> Options check the 'Show subtotals in the graph' checkbox if it is not already checked
.
5. Go to Series -> Total Revenue. Change the Show Selected Series As 'Line' from the dropdown menu, uncheck 'Show Markers on Line', and check 'Show Data Labels'.
6. Finally, go to Series -> Total Revenue -> Line, and set Transparency to 100, as shown below. Press OK.
7. The graph should display as shown below.
By following the same steps as above for a horizontal stacked bar graph, the graph will display as follows:
