Chart

[Raman]

I have the following data

Label x-value y-value
A 1 2
B 2 4
C 3 5

I would like to plot this on an using X-Y Scatter plot.
That works fine. However, I would like the X-axis to have
the labels (A, B, C) instead of 1, 2, 3. I there a way
that I can do that?

Thanks.

 

[Debra Dalgleish]

Jon Peltier has instructions for creating an arbitrary axis scale:

http://www.peltiertech.com/Excel/Charts/ArbitraryAxis.html

 

[Jon Peltier]

Raman -

If you don't care that the letters are equally spaced despite the data
(the same for X = 1, 2, 3 as for X = 1, 2, 10), you can just make a Line
chart, then double click on the series, and on the Patterns tab, choose
None for Lines.

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