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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,447
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,175,514
Messages
5,897,870
Members
434,684
Latest member
Mochi1

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