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

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

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" <mattgoof2005@discussions.microsoft.com> wrote in message
news:77A626B4-6F9E-417D-8792-BC0A5B0139FB@microsoft.com...
>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
>>
>>