Forum Discussion
repeat y axis in stack area for better readability
Hi,
I am new to excel, so please excuse if it has been answered before.
I am trying to repeat the values on y axis for better readability in stack area plot.
e.g in the attached plot I want to repeat the same percentage values on opposite y axis. How can I do it?
create a dummy series, like 10,20,30,40,50,60,70... and add it to your graph. Plot it on the secondary axis.
Now edit the axis to match the primary. I.e start at 0, end at 100, and then edit the series so there is nothing shown. Ie no fill, no line, no data points etc.
The end result looks like the primary is mirrored, when really you just have an identical secondary.
3 Replies
create a dummy series, like 10,20,30,40,50,60,70... and add it to your graph. Plot it on the secondary axis.
Now edit the axis to match the primary. I.e start at 0, end at 100, and then edit the series so there is nothing shown. Ie no fill, no line, no data points etc.
The end result looks like the primary is mirrored, when really you just have an identical secondary.
I appreciate your response. However, I am not very clear about how to add the dummy series to graph. I currently have some data that I select and generate the plot. By, default it gets mapped to x and y axis. How can I add a series and map it to a different y axis?
I got it. Thank You!
