Hello,
I am trying to create a stacked clustered column graph for 2 data sets. I would like sales $ to be on the vertical axis and month on the horizontal axis but I would like 2 columns for each month - one column for X Sales $ with their sub categories stacked and another for Y Sales $ with their subcategories stacked. Then I would like to add sales % change as a line chart on a different axis. Attached is some sample data along with a drawing with how I would like the chart.
Thanks!
Bookmarks