Automatically create chart images

[lbspiers]

Hi everyone,

I currently need to create around 1200 chart images using excel for a report series I am performing for a client. I have been trying all kinds of different things, all failures, to automate this process. My current method is to filter a pivot table on the building I am analyzing, copying the chart, pasting it as a picture in Ms Word, then saving that image as a Picture. Obviously, this process is quite lengthy, especially if I multiply that over the course of all 1200 images.

I am looking for a solution using a macro, vba, or a combination of things to help me automate this process and maybe even create the jpgs automatically, any ideas?

Thanks in advance,

Logan Spiers

 

[lbspiers]

I plan on mail merging the images into a Report document. I have seen several places on how to create a chart in VBA, I am pretty confident I can perform that coding, I guess more specifically my question is how would I tell VBA "After making this chart, make the next one until the final record."?