Change Y-axis tick labels to text, possible?

I

intoit

Hi,

Suppose one has data scored from 0 to 5 for 3 variables and the
corresponding bar chart's Y-axis has 6 tick labels 0 1 2 3 4 5 running
along the Y-axis. It it possible to change these tick labels to text (say,
Strongly Disagree, Disagree, Neutral, etc)? I noticed that if one copies a
chart into powerpoint and then 'ungroups' the elements of the chart, the
Y-axis tick labels can be changed, but it doesn't seem possible within excel
(nb: I want to write a macro within excel to perform this task).

Thanks for any advice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Changing y axis labels 1
Y-axis tick marks 2
x axis tick mark labels 1
showing start of each month as tick mark & label on X-Y chart 1
Possible? Variable X and Y data sources and Auto Charting 0
y-axis auto scaling... 2

Top