Graphing a Secondary Y axis -

JeremyDunn

New Member
Joined
Sep 20, 2006
Messages
12
Hi,

I am trying to graph 3 data sets. 1 data set represents integers while the other 2 data sets represent percentages. I want to represent the integers on the primary Y axis as a column graph while I want the other 2 data sets that are percentages represented on the secondary Y axis as 2 line graphs.

The "Line - column on 2 axes" custom chart within the wizard puts 2 of the data sets on the primary Y axis as column graphs and I cant work out how to change it so that the 2 data sets are represented on the secondary Y axis. I have included the data sets below. Any help you could provide would be much appreciated.

Thanks.
Jeremy


Profit Increase in Price Increase in Margin
7500 0% 0%
8500 2% 13%
9500 4% 24%
10500 6% 32%
11500 8% 38%
12500 10% 43%
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
Select the data series on the graph
Right Click
Select format data series
Select axis tab
Select plot on secondary axis

Hopefully that should do it
 

JeremyDunn

New Member
Joined
Sep 20, 2006
Messages
12
Hi Gord,

Ive tried that however excel places the first 2 data sets on the primary axis as a column graph and the the third data set on the secondary axis as a line graph.

I need the two percentage data sets on the one axis as a line graph and I cant get excel to do it.. If anyone can answer this one Ill be impressed.

Thanks
Jeremy
 

Forum statistics

Threads
1,141,070
Messages
5,704,112
Members
421,327
Latest member
Msh

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
Top