View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Grpahical selection of points on Excel charts

HowTo,

You can't do that automatically, not through a macro.

HTH,
Bernie
MS Excel MVP

"HowTo" wrote in message
...
I have a scatter plot in one of my excel workbooks, based on data in one

of it's sheets. I would like to be able to "select" a set of points on the
scatter chart (maybe by drawing a box around them). I would then like to
automatically select the corresponding series/values in the spreadsheet
containing the data for the scatter plot. How can I accomplish this?