PDA

View Full Version : How to change axis value in excel 2000



17-07-2001, 12:13 PM
All very simple you may say, but here is the problem.

I have a graph, y axis value 0-6 which is fine, the x axis shows 65 clients.

The trouble is there is a client number 7 and a client number 7A, the last client number should be 64.

How do I change the values of the x axis to show client numbers from 1-7,7A,8-64?

17-07-2001, 02:10 PM
Saul,

To substitute the X-axis with your own X-axis labels, go to Chart, select 'Data Source...' and click the Series tab. Click the cursor in the 'Category (X) axis labels:' box and select the range of cells containing the X-axis labels. The X-axis will now display 1, 2, 3, 4, 5, 6, 7, 7a, 8, 9, 10, ...