Share via

Save an Excel Chart as a separate PDF page

Anonymous
2010-06-22T14:54:25+00:00

I have several embedded excel charts on a worksheet.  I'd like to save them as PDF files.    I've got this snipped of code

      myChtObj.Chart.ExportAsFixedFormat _

                Type:=0, _

                Filename:=myPath & myChtObj.Name & ".pdf", _

                Quality:=0, _

                IncludeDocProperties:=True, _

                IgnorePrintAreas:=False, _

                OpenAfterPublish:=False

Which seems to save a copy of the worksheet as the PDF, not the chart.    What needs to be changed?

Thanks,

Barb Reinhardt

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-06-25T16:32:57+00:00

    Another way you can do that is simply clicking on the chart(s) and selecting print from the office button. When the print dialog comes up, change the printer to Adobe PDF and in "Print what" select "selected chart" (for excel 2007, that's the default). This will save your charts in PDF. You can only print/save one chart at a time.

    6 people found this answer helpful.
    0 comments
  2. Anonymous
    2012-01-19T11:27:17+00:00

    Portable Document Format

    see:

    http://en.wikipedia.org/wiki/PDF

    0 comments
  3. Anonymous
    2012-01-19T04:18:01+00:00

    can anyone please tell me what PDF means what does the P mean and the D means and the F whatdoesit mean please cant get an answer anywhere THANK YOU SO SO VERY MUCH FOR TAKING THE TIME TO HELP I OWE U 1

    0 comments
  4. Anonymous
    2010-09-29T13:41:23+00:00

    The problem is that the PDF file from an Excel 2007 chart is very deeply wrecked. The lines are roughly pixelised. I work with Windows 7. No matter if the file is an .xls or an .xlsx file.

    The problem does not exist when I open the .xls file with Excel 2003.

    The bug is very frustrating. Any help (update?) will be very much appreciated

    0 comments
  5. Anonymous
    2010-06-22T15:39:17+00:00

    Hi,

    Looks like you need to select the chartobject first.

    Sub x()

        Dim objCht As Chart

        Set objCht = ActiveSheet.ChartObjects(1).Chart

        objCht.Parent.Activate

        objCht.ExportAsFixedFormat xlTypePDF, "C:\temp\xx.pdf"

    End Sub

    Cheers   www.andypope.info

    0 comments