Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anybody have a routine to turn scatter plot points "on" or "off" on a
chart using, say, a mouse action, that would grab the point and put it into a second series, thereby changing the color and/or symbol? This would be a great benefit to removing outliers when adding trendlines. I've tried writing a little VBA , but didn't get anywhere since I can't seem to get Excel to identify the X-Y point locations outside of the actual values (row-column would be better) which, if you deal with 10,000+ pairs doesn't help much. Thanks for any help in advance. -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to bring data points to front on a scatter plot? | Charts and Charting in Excel | |||
how to add data points to a scatter plot with trend line | Charts and Charting in Excel | |||
How do i show duplicate data points on a scatter plot? | Charts and Charting in Excel | |||
How do I make my data points not overlap in a scatter plot? | Charts and Charting in Excel | |||
How do I have unique data labels for points in a XY Scatter plot? | Charts and Charting in Excel |