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


Hi,
Can I do it with some VB/C++ programming? Specifically, does the chart object allow more granular control on selection of points?
Thanks


"Bernie Deitrick" wrote:

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?