Replace numbers on x-axis of scatter chart with text eg 1 - one
 

I want to replace numbers on the x-axis of a scatter plot with text labels.

Replace numbers on x-axis of scatter chart with text eg 1 - one
 

Hi,

You can use a similar approach as described here.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

sfran19 wrote:
I want to replace numbers on the x-axis of a scatter plot with text labels.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Replace numbers on x-axis of scatter chart with text eg 1 - on
 

Thanks Andy,
What I want to do is replace numbers with categories on the x-axis. I'll
see if I can use the approach that you describe for changing categories on
the y-axis.

"Andy Pope" wrote:

Hi,

You can use a similar approach as described here.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

sfran19 wrote:
I want to replace numbers on the x-axis of a scatter plot with text labels.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Replace numbers on x-axis of scatter chart with text eg 1 - one
 

Perhaps the technique in this page is easier to implement:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

You can use a similar approach as described here.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

sfran19 wrote:
I want to replace numbers on the x-axis of a scatter plot with text
labels.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info