Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
need more infomation on scatter charts?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
need more infomation on scatter charts?
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
need more infomation on scatter charts?
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
need more infomation on scatter charts?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Automatically Create Scatter Plot Charts | Charts and Charting in Excel | |||
scatter charts | Charts and Charting in Excel | |||
Frequencies in Scatter Charts | Charts and Charting in Excel | |||
Can I use xy scatter charts to plot absolute measurements? | Charts and Charting in Excel | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel |