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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scatter chart without numerical values 3
Nameing scattered data in chart (dot's) 10
X-Y scatter with names 2
Scatter Chart with non-numeric values on X axis 2
XY Scatter Plot - Non-numeric data 3
Line chart or scatter chart?? 17
text label in x-axis (scatter chart) 2
timeline chart within a scatter plot 3

Back
Top