software

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

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
Xvalue1Yvalue1
Xvalue2Yvalue2
....
XvaluenYvaluen

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Hi,

This is the data i'm having

5Ability to customize coverage10.471-6
23Capability to communicate unit-to-unit when not in system
coverage10.53012
27Coverage in rural/remote areas10.4551
28Coverage in urban canyons10.460-41
48In-building coverage10.57625
70No coverage dead spots within desired coverage area10.46520
86Size of coverage area (coverage footprint)10.63661
19Acceptable level of blocked communications due to traffic
congestion20.464-13
21Battery life20.57968
67Minimal interference20.59537
71No lost connections or application failures20.59577
24Capacity at location of a disaster30.506-26
56Intrinsically safe/approved for use where flammable gases, vapors may
exist30.456-50
74Operational during time of disaster30.5228
76Priority access to system30.5892
84Reserved capacity for times of crisis30.377-13
33Device quality40.71971
34Device ruggedness40.63034
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

quot;Andy Popequot; wrote:

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

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.
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:
gt; Hi,
gt;
gt; This is the data i'm having
gt;
gt; 5Ability to customize coverage10.471-6
gt; 23Capability to communicate unit-to-unit when not in system
gt; coverage10.53012
gt; 27Coverage in rural/remote areas10.4551
gt; 28Coverage in urban canyons10.460-41
gt; 48In-building coverage10.57625
gt; 70No coverage dead spots within desired coverage area10.46520
gt; 86Size of coverage area (coverage footprint)10.63661
gt; 19Acceptable level of blocked communications due to traffic
gt; congestion20.464-13
gt; 21Battery life20.57968
gt; 67Minimal interference20.59537
gt; 71No lost connections or application failures20.59577
gt; 24Capacity at location of a disaster30.506-26
gt; 56Intrinsically safe/approved for use where flammable gases, vapors may
gt; exist30.456-50
gt; 74Operational during time of disaster30.5228
gt; 76Priority access to system30.5892
gt; 84Reserved capacity for times of crisis30.377-13
gt; 33Device quality40.71971
gt; 34Device ruggedness40.63034
gt;
gt;
gt;
gt; the first number is for example number, the text is for attribute, third
gt; number is color code, fourth X correlation, fifth is Y maximum difference
gt;
gt; There is overlaping of numbers in further data
gt;
gt; Thanks
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Hi,
gt;gt;
gt;gt;To create a scatter chart you need a minimum of a set of Y values.
gt;gt;Select the row or column of cells and using the chart wizard create a
gt;gt;xy-scatter. With only 1 set of values the chart will default to an
gt;gt;incremental set of x values ranging from 1 to the number of cells in the
gt;gt;Y range.
gt;gt;
gt;gt;If you have a set of x values as well then select both sets of data.
gt;gt;If you have your data in 2 columns the best layout for the chart wizard is
gt;gt;Xvalue1Yvalue1
gt;gt;Xvalue2Yvalue2
gt;gt;....
gt;gt;XvaluenYvaluen
gt;gt;
gt;gt;If you still have problems maybe you could elaborate on what options you
gt;gt;think are lacking.
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;zaka wrote:
gt;gt;
gt;gt;gt;i tried to create scatter chart, but was not able to do becaues of lack of
gt;gt;gt;options and assistance. could any one please help me
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info