View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard John Richard John is offline
external usenet poster
 
Posts: 5
Default Customise Graph Data labels

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)