Second axis on microsoft excel

[Handford]

I have a graph with a plot of how the readership of a magasine changes with time. On the left hand axis is quoted number of readers. I would like to put on the left hand axis the percentage of population covered (i.e. number of readers/total pop *100).

I am having difficulty doing this. Any ideas?

Thanks

Handford

 

[GlennUK]

Explain how you want this to look exactly please? It sounds like you are asking for 2 axes on the left? Or is it that you want the Percentage axis to replace what you already have?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Handford]

Sorry, was a typo. I simply want to put the percentages on the RIGHT axis of the graph. Just a set of tick marks to show what the absolute figures on the left mean.

Sorry about confusion!

Chris

 

[GlennUK]

Have an extra series of percentages and add them to the graph, select the series, and choose "Secondary axis" for it, then make ( you can choose non-colour, and no symbols, if you want it invisible, assuming line graph ).

Make the max scale of the right hand axis 100% and the max scale of the left-hand axis to equal the total population.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.