Stacked Chart With Secondary Axis
I'm trying to do a stacked chart, based on reasons for returns. The chart for January is okay for last month, but going forward they want to see the reasons stacked and Customer Returns in $ on one axis and % Monthly Sales on the other axis.
I can do a stacked chart, but I can't get it to add the secondary axis correctly.
Any idea how I can do this going forward?
Daily Returns Report (Excel Forum).xlsx
Mich
So you want to use a stacked column chart for each of axis? I am pretty sure that unless you manually fix the scale of one axis or the other the columns will share the same proportions and overlap perfectly. To counteract this a format option for the data series allows you to change the series overlap. I don't know if this is the issue you are asking about, but I hope it helps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks