need more infomation on scatter charts?

[zaka]

i tried to create scatter chart, but was not able to do becaues of lack of
options and assistance. could any one please help me

[Andy Pope]

Hi,

To create a scatter chart you need a minimum of a set of Y values.
Select the row or column of cells and using the chart wizard create a
xy-scatter. With only 1 set of values the chart will default to an
incremental set of x values ranging from 1 to the number of cells in the
Y range.

If you have a set of x values as well then select both sets of data.
If you have your data in 2 columns the best layout for the chart wizard is
Xvalue1 Yvalue1
Xvalue2 Yvalue2
....
Xvaluen Yvaluen

If you still have problems maybe you could elaborate on what options you
think are lacking.

Cheers
Andy

zaka wrote:
> i tried to create scatter chart, but was not able to do becaues of lack of
> options and assistance. could any one please help me

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

[zaka]

Hi,

This is the data i'm having

5 Ability to customize coverage 1 0.471 -6
23 Capability to communicate unit-to-unit when not in system
coverage 1 0.530 12
27 Coverage in rural/remote areas 1 0.455 1
28 Coverage in urban canyons 1 0.460 -41
48 In-building coverage 1 0.576 25
70 No coverage dead spots within desired coverage area 1 0.465 20
86 Size of coverage area (coverage footprint) 1 0.636 61
19 Acceptable level of blocked communications due to traffic
congestion 2 0.464 -13
21 Battery life 2 0.579 68
67 Minimal interference 2 0.595 37
71 No lost connections or application failures 2 0.595 77
24 Capacity at location of a disaster 3 0.506 -26
56 Intrinsically safe/approved for use where flammable gases, vapors may
exist 3 0.456 -50
74 Operational during time of disaster 3 0.522 8
76 Priority access to system 3 0.589 2
84 Reserved capacity for times of crisis 3 0.377 -13
33 Device quality 4 0.719 71
34 Device ruggedness 4 0.630 34



the first number is for example number, the text is for attribute, third
number is color code, fourth X correlation, fifth is Y maximum difference

There is overlaping of numbers in further data

Thanks

"Andy Pope" wrote:

> Hi,
>
> To create a scatter chart you need a minimum of a set of Y values.
> Select the row or column of cells and using the chart wizard create a
> xy-scatter. With only 1 set of values the chart will default to an
> incremental set of x values ranging from 1 to the number of cells in the
> Y range.
>
> If you have a set of x values as well then select both sets of data.
> If you have your data in 2 columns the best layout for the chart wizard is
> Xvalue1 Yvalue1
> Xvalue2 Yvalue2
> ....
> Xvaluen Yvaluen
>
> If you still have problems maybe you could elaborate on what options you
> think are lacking.
>
> Cheers
> Andy
>
> zaka wrote:
> > i tried to create scatter chart, but was not able to do becaues of lack of
> > options and assistance. could any one please help me
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

[Andy Pope]

Assuming your data is in the range A1:E19, where C1:E1 are additional
column headers. You can create a xy scatter with 4 series.

=SERIES(,Sheet1!$D$2:$D$8,Sheet1!$E$2:$E$8,1)
=SERIES(,Sheet1!$D$9:$D$12,Sheet1!$E$9:$E$12,2)
=SERIES(,Sheet1!$D$13:$D$17,Sheet1!$E$13:$E$17,3)
=SERIES(,Sheet1!$D$18:$D$19,Sheet1!$E$18:$E$19,4)

You can then use a free addin to link the textual description to the
data points. Try Rob Bovey's xy chart labeler.
http://www.appspro.com/Utilities/ChartLabeler.htm

The overlapping of data label text can only be resolved by manually
changing the alignment property of each label or dragging the data label
to a new position with the mouse.

Cheers
Andy

zaka wrote:
> Hi,
>
> This is the data i'm having
>
> 5 Ability to customize coverage 1 0.471 -6
> 23 Capability to communicate unit-to-unit when not in system
> coverage 1 0.530 12
> 27 Coverage in rural/remote areas 1 0.455 1
> 28 Coverage in urban canyons 1 0.460 -41
> 48 In-building coverage 1 0.576 25
> 70 No coverage dead spots within desired coverage area 1 0.465 20
> 86 Size of coverage area (coverage footprint) 1 0.636 61
> 19 Acceptable level of blocked communications due to traffic
> congestion 2 0.464 -13
> 21 Battery life 2 0.579 68
> 67 Minimal interference 2 0.595 37
> 71 No lost connections or application failures 2 0.595 77
> 24 Capacity at location of a disaster 3 0.506 -26
> 56 Intrinsically safe/approved for use where flammable gases, vapors may
> exist 3 0.456 -50
> 74 Operational during time of disaster 3 0.522 8
> 76 Priority access to system 3 0.589 2
> 84 Reserved capacity for times of crisis 3 0.377 -13
> 33 Device quality 4 0.719 71
> 34 Device ruggedness 4 0.630 34
>
>
>
> the first number is for example number, the text is for attribute, third
> number is color code, fourth X correlation, fifth is Y maximum difference
>
> There is overlaping of numbers in further data
>
> Thanks
>
> "Andy Pope" wrote:
>
>
>>Hi,
>>
>>To create a scatter chart you need a minimum of a set of Y values.
>>Select the row or column of cells and using the chart wizard create a
>>xy-scatter. With only 1 set of values the chart will default to an
>>incremental set of x values ranging from 1 to the number of cells in the
>>Y range.
>>
>>If you have a set of x values as well then select both sets of data.
>>If you have your data in 2 columns the best layout for the chart wizard is
>>Xvalue1 Yvalue1
>>Xvalue2 Yvalue2
>>....
>>Xvaluen Yvaluen
>>
>>If you still have problems maybe you could elaborate on what options you
>>think are lacking.
>>
>>Cheers
>>Andy
>>
>>zaka wrote:
>>
>>>i tried to create scatter chart, but was not able to do becaues of lack of
>>>options and assistance. could any one please help me
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info