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.

Hi,

You can create your own axis labels with a dummy series and data labels.
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"intoit" wrote in message
...
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.