How do I change the y-axis on an Excel chart from numbers to words
 

I am plotting numbers which represent an activity for a machine. I would
like to substitute a description of the activity for the number on the chart.
Does anyone know how to do this?

How do I change the y-axis on an Excel chart from numbers to words
 

I hope this answers your question:
1.Right click on the chart
2.Select 'Source Data'
3.Select the 'Series' tab
4.In 'Values', clear the box and select the list of words you want to appear
on the Y axis (have this list written somewhere on a worksheet)
5.Click ok

Was this what you were after?

"WDGILBERT" wrote:

I am plotting numbers which represent an activity for a machine. I would
like to substitute a description of the activity for the number on the chart.
Does anyone know how to do this?

How do I change the y-axis on an Excel chart from numbers towords
 

This will plot everything as zero values, since they are all text.

You can fake it using one of these approaches:

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



A little stuck wrote:
I hope this answers your question:
1.Right click on the chart
2.Select 'Source Data'
3.Select the 'Series' tab
4.In 'Values', clear the box and select the list of words you want to appear
on the Y axis (have this list written somewhere on a worksheet)
5.Click ok

Was this what you were after?

"WDGILBERT" wrote:

I am plotting numbers which represent an activity for a machine. I would
like to substitute a description of the activity for the number on the chart.
Does anyone know how to do this?

How do I change the y-axis on an Excel chart from numbers to w
 

This add-on works great, but I would like to be able to incorporate this into
a macro that I am using to process the data and create the chart. I am
guessing that this is not possible. What do you think?

"Jon Peltier" wrote:

This will plot everything as zero values, since they are all text.

You can fake it using one of these approaches:

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



A little stuck wrote:
I hope this answers your question:
1.Right click on the chart
2.Select 'Source Data'
3.Select the 'Series' tab
4.In 'Values', clear the box and select the list of words you want to appear
on the Y axis (have this list written somewhere on a worksheet)
5.Click ok

Was this what you were after?

"WDGILBERT" wrote:

I am plotting numbers which represent an activity for a machine. I would
like to substitute a description of the activity for the number on the chart.
Does anyone know how to do this?

How do I change the y-axis on an Excel chart from numbers tow
 

Which add-in? The Labeler? According to Rob's documentation, he has
modified the Labeler to allow it to be used by other VBA procedures. He
does not show how, unfortunately.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



WDGILBERT wrote:
This add-on works great, but I would like to be able to incorporate this into
a macro that I am using to process the data and create the chart. I am
guessing that this is not possible. What do you think?

"Jon Peltier" wrote:

This will plot everything as zero values, since they are all text.

You can fake it using one of these approaches:

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



A little stuck wrote:
I hope this answers your question:
1.Right click on the chart
2.Select 'Source Data'
3.Select the 'Series' tab
4.In 'Values', clear the box and select the list of words you want to appear
on the Y axis (have this list written somewhere on a worksheet)
5.Click ok

Was this what you were after?

"WDGILBERT" wrote:

I am plotting numbers which represent an activity for a machine. I would
like to substitute a description of the activity for the number on the chart.
Does anyone know how to do this?

How do I change the y-axis on an Excel chart from numbers to w
 

I used the labeler. Maybe he will share this with us in th4 future.

"Jon Peltier" wrote:

Which add-in? The Labeler? According to Rob's documentation, he has
modified the Labeler to allow it to be used by other VBA procedures. He
does not show how, unfortunately.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



WDGILBERT wrote:
This add-on works great, but I would like to be able to incorporate this into
a macro that I am using to process the data and create the chart. I am
guessing that this is not possible. What do you think?

"Jon Peltier" wrote:

This will plot everything as zero values, since they are all text.

You can fake it using one of these approaches:

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



A little stuck wrote:
I hope this answers your question:
1.Right click on the chart
2.Select 'Source Data'
3.Select the 'Series' tab
4.In 'Values', clear the box and select the list of words you want to appear
on the Y axis (have this list written somewhere on a worksheet)
5.Click ok

Was this what you were after?

"WDGILBERT" wrote:

I am plotting numbers which represent an activity for a machine. I would
like to substitute a description of the activity for the number on the chart.
Does anyone know how to do this?

How do I change the y-axis on an Excel chart from numbers to w
 

For future reference, the information on how to use this in a macro is
included in the help for XY Chart Labeler. I tried it and it works. Thanks
for your help!

"Jon Peltier" wrote:

Which add-in? The Labeler? According to Rob's documentation, he has
modified the Labeler to allow it to be used by other VBA procedures. He
does not show how, unfortunately.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



WDGILBERT wrote:
This add-on works great, but I would like to be able to incorporate this into
a macro that I am using to process the data and create the chart. I am
guessing that this is not possible. What do you think?

"Jon Peltier" wrote:

This will plot everything as zero values, since they are all text.

You can fake it using one of these approaches:

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



A little stuck wrote:
I hope this answers your question:
1.Right click on the chart
2.Select 'Source Data'
3.Select the 'Series' tab
4.In 'Values', clear the box and select the list of words you want to appear
on the Y axis (have this list written somewhere on a worksheet)
5.Click ok

Was this what you were after?

"WDGILBERT" wrote:

I am plotting numbers which represent an activity for a machine. I would
like to substitute a description of the activity for the number on the chart.
Does anyone know how to do this?