Two axes in Excel

  elgar 23:51 12 Mar 2006
Locked

I am trying to do a chart showing exam results for a group of students.

I want to show the results of two exams with grade on the X axis and number of students on thr Y. So far so good. I also want to show on the right hand axis the percentage of students at that grade. I have tried adding a secondary axis using format but cannot seem to get the %ages to show

  VoG II 01:10 13 Mar 2006

You need to create an additional column or row containing the percentages. Select those data, Copy. Go to the chart, Edit/Paste Special to add the new series to the chart. Then right click the new series and tell Excel to plot the values on the secondary axis.

  VoG II 01:27 13 Mar 2006

See office.microsoft.com/en-gb/ assistance/HP052016901033.aspx

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?