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
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.
Re: Double Y Axis Graph
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
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
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks