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.
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.