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!

Changing Y-Axis Labels from Numerical to Textual
 

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

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