Changing Y Axis Values

[veritone]

Hi, I am making a regular line chart, however, I would like to change the values of the y-axis similar to the ability to change the x axis. What I really want is to have the x and y axis be text (and not numbers...) ie. I would like to set 50 (the middle of the chart) to be a letter, like x, and 2x and "0" to the chart. Thanks!

 

[ThePencilQueen]

You could cheat and add another data series of x=0 and put the labels on that using the xy labeler addin?

 

[Mark W.]

On 2002-10-21 08:02, veritone wrote:
Hi, I am making a regular line chart, however, I would like to change the values of the y-axis similar to the ability to change the x axis. What I really want is to have the x and y axis be text (and not numbers...) ie. I would like to set 50 (the middle of the chart) to be a letter, like x, and 2x and "0" to the chart. Thanks!

Sorry, the only Excel chart that supports categories on the Y-axis is a Bar Chart type... and that chart's X-axis must then be a value axis.
This message was edited by Mark W. on 2002-10-21 12:11