I have written a macro that uses the data-analysis tool to creat a
histogram. It turns out too small and I have to manually enlarge it. I
can't seem to do it in the macro, because one has to select thee chart
and I can't figure out how to do this since it reuires a chart number
to select it. And of course the number changes every time the macro is
run.

So my question is: In a VBA macro how do I select the only chart when
I will not know it's number. Help will be appreciated. Thank you.