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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
Back
Top