Jonas S.


Hi all,

I am creating charts inside VBA code and I wonder how I can make them be located directly under eachother.

The first plot is located with :

Charts.Add
ActiveChart.Location = Worksheets("BUS").Range("D27")

But how do I type the location for the other charts that will be created so they get the location under eachother I want it to be controled by the first plot's location.

Grateful for help.

Jonas





Re: how to fit charts to eachother in excel

Andy Pope


Hi,

It just so happens John Mansfield has blogger on the very subject.
http://www.cellmatrix.net/index.php/align_charts_to_worksheet_grid_via_chart_names/






Re: how to fit charts to eachother in excel

Jonas S.

Just links nowadays, are you getting lazy Andy :-)

Just kidding, thanks seems to be what I was looking for.

\Jonas







Re: how to fit charts to eachother in excel

Andy Pope

me, lazy, how could you even think such a thing <bg>




Re: how to fit charts to eachother in excel

Jonas S.

worked perfect Andy.

Thanks a lot.

\Jonas