Code to return the data a chart is based on

  • Thread starter Thread starter dracstorey
  • Start date Start date
D

dracstorey

Anone know of an method in VBA which will return the data series an
existing graph or chart is based on?

I cannot I find any code to return the data series that a chart is
based on. (i.e. return "C4:C7"). It seems an obvious thing to want to
do but ...


Andrew
 
Many thanks Tom. I'm glad he says there is a serious flaw (I thought I
was going mad!). I will try his code and hopefully it will solve the
problem.

Thanks again

Andrew
 
Problem nearly solved. I have very nearly integerated the code into
mine. Just a couple of bugs for me to deal with but therange is indeed
returned!

Many thanks

Andrew
 
Back
Top