how to track named range in a chart

[JayeshG]

Hi all,

Is there any way to track named range in chart. I mean is it possible to detect if a given named range is used within a chart with the help of VBA?

Thanks!

[Andy Pope]

You can use VBA to check the series formula property. This is a string showing all references for series name,categorylabels,values,plotorder,[bubblesize]