Really basic help with a graph

  • Thread starter Thread starter clfpele
  • Start date Start date
C

clfpele

Right, all I want to do is plot some points in a graph.

I have 2 categories, influence and importance.

the x axis is influence, the y axis is importance.

Lets say I want to plot a point in a chart to show that George Bush
scores 10 on each scale, whereas David Beckham scores 4 for importance
and 7 for influence (let's say).

How can I make excel represent these as single points in a graph in a
graph?!?
 
A B C
Person Influence Importance
GW 10 10
Beckham 7 4

Under Series, Name=$A$2, X=$B$2, Y=$C$2

You'll have to do this for each series, but it'll get you started if nobody
else has any ideas.
 
Or with a list, columns A-C as Matt suggests, plot B and C as your X and Y,
then use one of these utilities to apply the labels in column A to the
points you've just plotted:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
 
Back
Top