Changing the axis infromation in an Excel graph | Excel forum

Hi Nicky, thanks for your query. You can't alter the scale at the bottom of the y-axis (unless you do it graphically) but try this. Click once on the "No of training courses" line, then right click on it and Format Data Series. Then choose Plot on Secondary Axis. That will give you another axis on the right of the chart and the "No of training courses" should be much clearer on the chart.

Hope this helps,

Anthony