Is numeric "Series Axis" possible?

[fendwick]

When I make a simple 3-D surface chart in Excel, the "series axis" i
automatically displayed as S1, S2, etc. Is there a convenient way t
have that axis display numbers instead?

For example: the following surface is generated by multiplying th
x-value to the y-value:


5 10 15
4 8 12
2 3

However,the Y (series) axis (4 and 5) automatically defaults to S1 an
S2; I know I can change the names of the series to match, but I wis
they would change automatically if I were to change the Y-axis values
(e.g. from 4 and 5 to: 1 and 2)


2 4 6
1 2 3
2 3


Any ideas

 

[Jon Peltier]

Do it this way, with the labels in the TOP row:

2 3
4 8 12
5 10 15

Make your chart with the data range that includes the top row and left
column (and blank top left cell).

Now, even though Excel doesn't recognize the numerical values of the
axis labels, at least it uses recognizable, meaningful labels.

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

 

[fendwick]

Thanks, Jon: that fixed it right up!!! :