View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I display non-numeric values in a scatter chart?

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" wrote in message
...
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!