Export all charts (embedded and single chart sheet) to a single PDF File

Hello,

I have multiple charts in a Excel Workbook. I want to export all of them in a PDF File, one chart on each page, is there a way to do that?

For example, let's say I have three worksheets and want to copy four charts.

Two of the sheets has a single chart each (I mean there is no cell, only the chart itself, as I moved them to a chart sheet): one named "MONTH BY LP P1 Cht", the other named "WEEK BY LP P1 Cht"
The other two charts are embedded in a worksheet named "AVG10P BY LP", so, each chart has a name, Chart000 and Chart 0001 are their names.

Thanks.

Hummm looks like it is copying only from a unique WorkSheet, in this case is "Slice". Will try to find a way to loop thru the Worksheets..

I was able to loop through worksheets copying the charts on a temporary worksheet, however, I am unable to select a chart which is a chart sheet. For example, I tried below to select "Chart1". Maybe it is another way to reference it.

This is what I used to loop:

Please Login or Register  to view this content.