Changing Y-Axis Labels from Numerical to Textual

I've searched the forums and this thread was the closest thing I could
find to my question/answer:
http://groups.google.com/group/micro...e9d9fcfbbfa9aa

Essentially, I have a set of data that assigns numerical values to
satisfaction levels (i.e. "Very Satisfied" = 5, "Very dissatisfied" =
0). I want to make a bar chart that displays categories on the x-axis
while also showing satisfaction levels on the y-axis. Right now, the
y-axis shows only the numerical values instead of the text "Very
Satisfied" to "Very Dissatisfied." How can I edit the labels to show
this? Please advise... am much obliged!

Hi,

Jon Peltier has an explanation of how to create an textual Y axis.
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

You may also find my Tile chart of interest.
http://www.andypope.info/charts/tilechart.htm

Cheers
Andy

[email protected] wrote:
> I've searched the forums and this thread was the closest thing I could
> find to my question/answer:
> http://groups.google.com/group/micro...e9d9fcfbbfa9aa
>
> Essentially, I have a set of data that assigns numerical values to
> satisfaction levels (i.e. "Very Satisfied" = 5, "Very dissatisfied" =
> 0). I want to make a bar chart that displays categories on the x-axis
> while also showing satisfaction levels on the y-axis. Right now, the
> y-axis shows only the numerical values instead of the text "Very
> Satisfied" to "Very Dissatisfied." How can I edit the labels to show
> this? Please advise... am much obliged!
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info