A line Graph with 1 x axis and multiple y axes

learninman

New Member
Joined
Aug 1, 2011
Messages
29
Hi
Is there a way to make a line graph with a regular x axis and multiple y axes. I know you can have a data set and make appear on the secondary axis (which means you would have two y axes) but is there a way to have more than two? the reason i need this is because i want to have 4 line graphs drawn on one chart and the data of the y axes of these different data sets have very different scales so when I do plot them all it looks like three of them are just flat and constant zero.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
I guess I could change the scale of my own data, but I would prefer not to.
I found out that this is called making tertiary axis but I have not been able to find out how to do this.
 
Upvote 0

Forum statistics

Threads
1,224,591
Messages
6,179,767
Members
452,940
Latest member
rootytrip

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top