Forum Discussion

meetasinha's avatar
meetasinha
Copper Contributor
Aug 29, 2018
Solved

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...
  • Philip West's avatar
    Aug 29, 2018

    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.

Resources