return chart's source data location/range

H

HD

Hi,

I am trying to figure out if anyone knows how to have excel (vba) code to
return the source location of where the chart is getting its data from.
Ex: if i were to select a chart it will highlight the cells where it is
getting its data from to plot. what is the command (code) to have it return
the range ( : ) into a variable in vba ?
 
J

Jim Cone

Not an easy one, see what John Walkenbach has to say...
http://j-walk.com/ss/excel/tips/tip83.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"HD"
wrote in message
Hi,
I am trying to figure out if anyone knows how to have excel (vba) code to
return the source location of where the chart is getting its data from.
Ex: if i were to select a chart it will highlight the cells where it is
getting its data from to plot. what is the command (code) to have it return
the range ( : ) into a variable in vba ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Hilight Chart's Source Data? 4
changing the source range of a chart 3
Embedded chart location address 2
Help: Chart & data 1
How to identify Chart Source data as range? 3
use ComboBox value to select range and then use selected range tocreate a chart 3
How I can set dynamic pivot table ONLY when I have enough data point 1
VBA set thick borders around non empty cells in range 0

Top