Help with an Excel Scatter gram

[sandybam]

Hi All,

I am trying to put together a scatter gram in Excel to show how many colleagues are falling within a particular percentile. My range is from 85% - 100%. I have tried to use a roll up of my data and the full data set and I get the same result either way, one dot for each percentile. If there are 5 colleagues falling within 95% I want to see 5 dots not one. Is this possible?

Thank you for your help.

 

[SkipVought]

sandybam,

Please post a sample of yuor source data.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sandybam]

Here you go:

Rollup:
Range 100 99 98 97 96 95
February 0 0 3 2 1 4
March 0 0 2 1 3 1

Or All Data:

Feb March
98 98
98 98
98 97
97 96
97 96
96 96
95 95
95
95
95

Thank you,

 

[SkipVought]

I got 5 points for each row???

What chart type are you using?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sandybam]

The XY Scatter.

Thank you,

Sandy

 

[SkipVought]

From your data
[tt]
Range 100 99 98 97 96 95
February 0 0 3 2 1 4
[/tt]
for February I have 6 points...
100,0
99,0
98,3
97,2
96,1
95,4

Is this NOT what you want to see?

If not, then what?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sandybam]

Sorry, I misunderstood your previous post. I would like to see 10 dots. I would like to see where the large clusters of dots fall to see if we can move a standard up.

Thank you,

 

[SkipVought]

Please explain what your chart is displaying with this source data...
[tt]
Range 100 99 98 97 96 95
February 0 0 3 2 1 4
March 0 0 2 1 3 1
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sandybam]

I have two sets of dots for each of the ranges, a total of 10 dots. There is one dot represented for each percentile. For instance, there is one dot for 95% instead of 4 dots. When I hold my cursor over the dot it will tell me that that dot represents 4 however this is not useful once the report is printed or for quick views. Is this possible?

Thank you,

 

[SkipVought]

How would you represent 4 dots???
[tt]
4- *

3-

2-

1- +

------
95

[/tt]
4 dots means 4 series instead of 1?????


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884