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)
(E-Mail Removed)

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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)
> (E-Mail Removed)
>
>

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
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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)
>> (E-Mail Removed)
>>
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:ue8$(E-Mail Removed)...
> 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
> news:%(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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)
>>> (E-Mail Removed)
>>>
>>>
>>
>>
>
>