How to create a second Y axis in Excel 2010
Solved
DK
-
Kami -
Kami -
Hello,
I’m looking to create a chart containing data to be rendered as a histogram (y = amount, x = years) and on top of it, a curve, per column, with a number of cases (i.e., the creation of a second Y-axis)
It’s the creation of this second axis that is causing me trouble
Does someone have a solution?
Thanks in advance
Configuration: Windows XP / Internet Explorer 8.0
I’m looking to create a chart containing data to be rendered as a histogram (y = amount, x = years) and on top of it, a curve, per column, with a number of cases (i.e., the creation of a second Y-axis)
It’s the creation of this second axis that is causing me trouble
Does someone have a solution?
Thanks in advance
Configuration: Windows XP / Internet Explorer 8.0
1 answer
-
Hello.
First, you create your chart as usual with your two histograms (amount, number of cases).
Right-click the histogram for the amounts and choose
Format Data Series / Secondary Axis / OK
Then right-click the histogram for the amounts again, but this time choose
Change Chart Type and select Line.
All that remains is to adjust the scales of the two vertical axes so that the horizontal gridlines align.
Best regards.
--
Nice retirement! Especially in the Antilles ... :-)
☻ Raymond ♂
