need more infomation on scatter charts?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Xvalue1 Yvalue1
Xvalue2 Yvalue2
....
Xvaluen Yvaluen

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

Cheers
Andy
 
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
 
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
 
Back
Top