VBA code to return the data series of a chart or graph

D

dracstorey

HELP! Does anyone know of some VB or VBA code which will return the dat
series on which a chart or graphis based. I have a column chart and ca
check that it has a title:

.ActiveSheet.ChartObjects(1).Chart.HasTitle

as above!

However I cannot find any method which returns the range of cells o
which a chart is based.

Any ideas welcomed to this forum or email:

[email protected]
[email protected]

Many thank
 
A

Andy Pope

Hi dracstorey,

Check out Jon's tutorial pages,
(http://peltiertech.com/Excel/Charts/ChgSrsFmla.html)
HELP! Does anyone know of some VB or VBA code which will return the data
series on which a chart or graphis based. I have a column chart and can
check that it has a title:

ActiveSheet.ChartObjects(1).Chart.HasTitle

as above!

However I cannot find any method which returns the range of cells on
which a chart is based.

Any ideas welcomed to this forum or email:

[email protected]
[email protected]

Many thanks
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
D

dracstorey

Tushar

many thanks. The link was great and I have nearly integrated it into my
code. Just a couple of fixes needed!

Andrew
 
T

Tushar Mehta

You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top