Hi Garry,

Am Sun, 25 Dec 2016 15:42:57 -0500 schrieb GS:

Making this data range 'dynamic' would be best so it self-sizes and
its chart auto-updates accordingly!

in my example the range names are dynamic. I thought this would be
obvious as I wrote :
Then your chart is always present with the current data.


Regards
Claus B.

I didn't view your sample, but no surprise that you did it that way!<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion