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.
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.