XL 2003: Replacing X-Axis Labels with Custom Ones...

B

Birmangirl

Is there any way of simply replacing my existing X-Axis labels with those of
my own definition, without having to add an additional data range?
XL insists on inserting a nicely scaled axis (say 1 to 10) and I'd like
1,2,3,E instead...
Any help appreciated...
 
J

Jon Peltier

The way to achieve this is to use another range that contains the X labels
you want. Is there a particular reason you don't want to do it this way?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

X-axis scale 1
X-Axis Appearing in Plot Area 2
Data labels along below x axis when y axis has negative values 1
Category (X) Axis Labels not found in Excel 2003 2
X-Axis Labels Bar Chart 1
X axis values on a line graph 1
Hide Graph of Data Outside X-Axis Range 2
Custom EXCEL chart value axis BRAIN TEASER 1

Top