Chart with Sub-Totals Info for Vertical axis
I want to create a report with a chart that has the following.
1. Display 2 sub totals (+/-) for each entry horizontal axis.
2. The sub totals are segmented by color based on the data entry (what contructs the sub-total).
3. The scales for the sub totals should be the same (in case of combined charts).
Currently, what happens is that the chart I'm created only has the legends for the 2 subtotals.
But I want it to be displayed based on what the subtotals are consists of.
Is there a way to do it?