View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default How to return the address of the range of plotted data on an XY scatter chart?

I can't figure out the VBA code that will return the address of the
range of data plotted on an embedded chart on say sheet1.
Everything I try just results in the "object does not support this
property or method" error message.
I've been recording macros for clues as well as studying the Object
Browser, all to no avail.

Any clues?

Ken Johnson