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

[Guest]

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!

 

[Jon Peltier]

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