Is there a way to substitute a textual description form a numeric value in
an Excel Graph? I want to replace a numeric survey response score, which is
on the y-axis of a graph, with a text description. e.g;
The Y axis has integer values from 1 to 5. I want the labels to say:
"Strongly Disagree" instead of 1
"Disagree" instead of 2
"Neutral" instead of 3
"Agree" instead of 4
"Strongly Agree" instead of 5
I've looked at the Excel Object Model but can't find anything that will let
me do it.
Ideas welcome... :-)
Regards
Richard John (aka RJ)