| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do i show duplicate data points on a scatter plot?
I need to show that duplicate points exist on a scatter plott used for
coorelation. Normaly a dot with a circle around it. Can I do this in excell? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do i show duplicate data points on a scatter plot?
Hi,
You can add a second series to ring the duplicate points. Assuming your x and y data is in A1:B20 place this formula in C1 and copy down. =IF(SUMPRODUCT(($A$1:$A$20=A1)*($B$1:$B$20=B1))1, B1,NA()) Create your xy scatter chart based on A1:C20. Format the first series as dots by changing the marker to a circle. Format the second series as dots as well but set the background colour to None and increase the size of the marker. For information on markers see here. http://www.andypope.info/tips/tip009.htm Cheers Andy Mr.Man wrote: I need to show that duplicate points exist on a scatter plott used for coorelation. Normaly a dot with a circle around it. Can I do this in excell? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do i show duplicate data points on a scatter plot?
Awsome!! Thanks!!
"Andy Pope" wrote: Hi, You can add a second series to ring the duplicate points. Assuming your x and y data is in A1:B20 place this formula in C1 and copy down. =IF(SUMPRODUCT(($A$1:$A$20=A1)*($B$1:$B$20=B1))1, B1,NA()) Create your xy scatter chart based on A1:C20. Format the first series as dots by changing the marker to a circle. Format the second series as dots as well but set the background colour to None and increase the size of the marker. For information on markers see here. http://www.andypope.info/tips/tip009.htm Cheers Andy Mr.Man wrote: I need to show that duplicate points exist on a scatter plott used for coorelation. Normaly a dot with a circle around it. Can I do this in excell? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line chart or scatter chart?? | Charts and Charting in Excel | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
| creating names for data shown on a scatter plot | Charts and Charting in Excel | |||
Linear Mode
