Options for labelling an axis when graphing with Excel
April 27, 2012 12:25 PM Subscribe
Excel graphing question: Is there a way to change the axis labels to something you are not graphing?
posted by jb to computers & internet (10 answers total) 2 users marked this as a favorite
I have some results of a survey which are numerical - but they are the numerical responses to a question like "How much do you like this?" where 1= Not at all, 2=Somewhat, 3=I love it!
So I'm graphing the average of the responses which are obviously numerical: the mean of Group A's average is 1.35, while the mean of Group B's is 2.46. And currently, the Y-Axis of my graph is labelled numerically (1, 2, 3, etc), as that is the range of values from which I have generated the graph.
However, I am graphing this for a research participant newsletter, and I would like to change the Y-axis labels from being the numbers (which have no meaning) to saying "Not at all", "Somewhat" and "I love it!"
Is this possible within Excel? (My other option is just to suppress the labels and add a textbox after I import the graph into Word, but that's bothersome).
(Yes, I know that there are better programs for graphing - our data analyst uses one. But I have to publish the newsletter using word, and it's easier to lay out colours, fonts, etc with Excel than to be using an image generated from another program).