Really basic help with a graph
 

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?!?


--
clfpele
------------------------------------------------------------------------
clfpele's Profile: http://www.excelforum.com/member.php...o&userid=36807
View this thread: http://www.excelforum.com/showthread...hreadid=565173

Really basic help with 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.


"clfpele" wrote:


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?!?


--
clfpele
------------------------------------------------------------------------
clfpele's Profile: http://www.excelforum.com/member.php...o&userid=36807
View this thread: http://www.excelforum.com/showthread...hreadid=565173

Really basic help with a graph
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


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


"clfpele" wrote:


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?!?


--
clfpele
------------------------------------------------------------------------
clfpele's Profile:
http://www.excelforum.com/member.php...o&userid=36807
View this thread:
http://www.excelforum.com/showthread...hreadid=565173