Displaying data graphically

[kylerickards]

Hi all

First time posting!

I have a spreadsheet with about 250 values in it, such as:

a - 210
b - 220
c - 215
d - 200

and so on... I wish to show all these values as discrete points on a chart along with the text associated with the value, I suppose I am after a matrix of the data showing all points in relation to each other. At the moment I am doing this as a scatter chart - is that the best way to show the data the way I want it to be?

Thanks in advance
Kyle

 

[Robert Mika]

Hi Kylie and welcome to the board:
Soemthing like that?

http://imageshack.us/photo/my-images/577/scatt.jpg/

 

[kylerickards]

Hi Robert

Yes, that's exactly it albeit with 250 bits of data

Is the way I am doing it right or is that a different type of chart?

Thanks
Kyle

 

[Robert Mika]

Not sure what you doing but if this what you trying to achive then:

Creatate a normal Pie Chart from all your 250 data point.
Then in option of the Labels add Category so you will get (a,210) then change the chart type to scatter.

Is that what you after?

 

[kylerickards]

Hi Robert

Yes, that's the way I have been doing it thus far but didn't know if there was a more elegant way of doing it. I also change the markers to represent groups of data within the 250.

Many thanks for your advice though - heartening to know I am on the right lines!

Kyle

EDIT: Actually this may be a different question for a different forum but is Excel my best choice to do this data representation in?