Two axes in Excel

  elgar 23:51 12 Mar 2006

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 assistance/HP052016901033.aspx

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

Elsewhere on IDG sites

Honor 9 Lite review

HomePod review

Les meilleurs logiciels de montage vidéo gratuits (2018)