Customise Graph Data labels

[Richard John]

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

"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)
(e-mail address removed)

 

[Peter T]

Hi Richard,

Put your various "agrees" in five cells, eg A1:A5

In a column (or row) near your y values a LookUp range, though as your
lookup values are consecutive numbers between 1 5 could simply use Index, eg

Assuming your y's are in E2 down, in say F2
=INDEX($A$1:$A$5,E2)
copy down

Apply labels the normal way (Show Value or Show label)
Select all the labels
Select the first label
in the input bar type "=F2" without quotes, ie = the text cell
repeat for the other labels

Here are two good addins to make it easier -
Rob Bovey's Chart Labeler,
http://appspro.com
John Walkenbach's Chart Tools,
http://j-walk.com/ss/excel/files/general.htm

Regards,
Peter T

 

[Richard John]

Thanks Peter,
Rob Bovey's "Chart Labeler" has provided a good alternative solution to what
I originally had in mind. John Walkenbach's Chart Tools is certainly worth
looking into as well. Good tools for the future.

Regards

RJ

 

[Jon Peltier]

Here are a couple techniques that will produce the chart you want:

http://peltiertech.com/Excel/Charts/DotPlot.html
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

- Jon