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%
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%