Excel graph question

  Tim1964 00:00 23 May 2008
Locked

Hi,

My son is using Excel's chart wizard to create a bar graph of a list of 20 items of data. The numbers (on the x axis) are 0.5, 1, 1.5, 2 up to 10. When he highlights the numbers it puts them in as 1 to 20 under the columns and not the numbers 1 to 10 in 0.5 increments. He can clear the numbers on the x axis and write them by hand but he would like it to be done 'properly'

How do we get it to show the incremental numbers?

Thanks,

  VoG II 09:33 23 May 2008

Excel can be a bit non-intuitive when it comes to charts. Assuming that the sheet is Sheet1, the X axis values are in A1:A20 and the Y axis values are in B1:B20 then

Select B1:B20 and use the Chart Wizard to create a bar graph. Then right click one of the bars and select Source data. On the Series tab > Category (X) axis labels enter

=Sheet1!A1:A20

and click OK.

You can then right click the X axis, select Format axis and adjust the decimal places etc. as required.

  Tim1964 23:17 23 May 2008

Thanks for the reply, we'll have a go tomorrow.

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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?