If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I copy x-y scatter plot data direct from one plot to another? | Chris | Charts and Charting | 2 | June 3rd, 2005 01:20 PM |
creating names for data shown on a scatter plot | budski | Charts and Charting | 1 | December 22nd, 2004 05:15 PM |
How many data points can you have in an Excel for a Scatter Chart. | gregran | Charts and Charting | 3 | December 10th, 2004 07:31 PM |
After upgrading to 2003 the scatter charts no longer show data la. | johnnyd4 | Charts and Charting | 2 | October 18th, 2004 08:14 PM |
Scatter plot changes to line plot with data gaps | Jim | Charts and Charting | 14 | October 8th, 2003 05:10 PM |