Change Y-axis tick labels to text, possible?
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. |
Change Y-axis tick labels to text, possible?
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. |
All times are GMT +1. The time now is 06:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com