How do I display non-numeric values in a scatter chart?

I'm trying to put together a scatter chart showing non-numeric magnitude, in
this case I want the axes to indicate 'least feasible-most feasible' and
'largest impact on poverty-smallest impact on poverty'. I presume that to do
this I must in some way attach two numeric values to each data point which I
have done, but I don't want this to be displayed numerically in the chart, I
only want to show each point relative to another. Is this possible? Many
thanks!

1. You need to assign numerical values to the quantities to be plotted.

2. You can hide the axis tick labels so no numbers appear: Double click the
axis, Patterns tab, choose None for Axis Tick Labels.

3. You can use textboxes to place your labels on the chart, or perhaps
create a fake axis with the labels you want as its data labels:

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

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


"iaintw" <iaintw@discussions.microsoft.com> wrote in message
news:27B28E68-EE19-4144-BCB6-EB54CA5F3DB3@microsoft.com...
> I'm trying to put together a scatter chart showing non-numeric magnitude,
> in
> this case I want the axes to indicate 'least feasible-most feasible' and
> 'largest impact on poverty-smallest impact on poverty'. I presume that to
> do
> this I must in some way attach two numeric values to each data point which
> I
> have done, but I don't want this to be displayed numerically in the chart,
> I
> only want to show each point relative to another. Is this possible? Many
> thanks!
>
>