| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 10330 | 2001-07-17 00:13:00 | How to change axis value in excel 2000 | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 15649 | 2001-07-17 00:13:00 | 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? |
Guest (0) | ||
| 15650 | 2001-07-17 02:10:00 | 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, ... |
Guest (0) | ||
| 1 | |||||