PDA

View Full Version : [SOLVED] How to find which columns are being used in active chart



madeline
01-27-2017, 12:56 PM
Is there any way to find which columns are being charted in the active chart?

I need to be able to take any chart, and find out which columns are being charted in it using a VBA macro.

I've been trying things like ActiveChart.FullSeriesCollection(1).Column with no success.

mancubus
01-27-2017, 02:46 PM
welcome to vbaexpress.

see if this thread helps...

http://www.vbaexpress.com/forum/showthread.php?30968-Finding-data-range-reference-for-a-series-in-chart-using-vba

madeline
01-27-2017, 02:56 PM
That page helped a lot. Thank you so much!:hi:

mancubus
01-27-2017, 04:30 PM
you are welcome.
pls mark the thread as solved (from threadtools) if you are sorted.