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)

Customise Graph Data labels
 

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" wrote in message
...
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)

Customise Graph Data labels
 

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



"Peter T" <peter_t@discussions wrote in message
...
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" wrote in message
...
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)

Customise Graph Data labels
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Richard John" wrote in message
...
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



"Peter T" <peter_t@discussions wrote in message
...
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" wrote in message
...
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)