Double Y Axis Graph

**Mid61n05** · 06-03-2009, 08:26 AM

Hi folks,

I know how to put a secondry axis on a graph but i would like the line on the 2nd axis to start from the bottom right hand corner so this crosses with the line which is plotted from the primary axis.

Any ideas because at the moment even though i have 2 lines both start from the 0 (zero) in the bottom left of the graph.

Your help is appreciated
Nathan

**Andy Pope** · 06-03-2009, 09:09 AM

You would need to add a secondary x axis and plot values in reverse.
Of course your chart type may affect this solution.

Post example workbook if you need more help.

**danob** · 12-29-2009, 09:03 AM

Hi ,

I am trying to plot the same data on two Y axis. So when read on the left it is an amount of a specific unit and on the right it's a percent of a defined total.

Any ideas??????

Dan

**teylyn** · 12-29-2009, 05:03 PM

Hi danob,

welcome to the board. Please do not post questions in the threads of other members. I see you've already started a new thread about your question, so keep the discussion restricted to there.

thanks