Skip to main content
J
jay fresno
Inspiring
February 9, 2016
Answered

Fit Excel chart to anchored frame

  • February 9, 2016
  • 3 replies
  • 423 views

The Excel charts are saved as PDF and then imported into FrameMaker 2015, into pre-made frames. The frames act as placeholders until the PDF pages are imported. Is there a way to automatically scale the PDF pages to fit into the pre-made frames upon import?

    This topic has been closed for replies.
    Correct answer Arnis Gubins

    If you are using the PDFCreator add-on to Excel, then all of the charts are exported to letter-sized PDFs and are scaled based upon your specified option in Excel (Actual Size, Fit to paper width, Fit Worksheet to single page).

    If all of the charts are the same size, then you could use an Object Style on the imported graphic to both scale and position as desired. IF the charts are different sizes, then it might not work that well as you may require quite a few Object Styles to cover all sizes [you can create any number of Object Styles, but this can get out of hand quickly].

    3 replies

    Arnis Gubins
    Arnis GubinsCorrect answer
    Inspiring
    February 10, 2016

    If you are using the PDFCreator add-on to Excel, then all of the charts are exported to letter-sized PDFs and are scaled based upon your specified option in Excel (Actual Size, Fit to paper width, Fit Worksheet to single page).

    If all of the charts are the same size, then you could use an Object Style on the imported graphic to both scale and position as desired. IF the charts are different sizes, then it might not work that well as you may require quite a few Object Styles to cover all sizes [you can create any number of Object Styles, but this can get out of hand quickly].

    Bob_Niland
    Community Expert
    Bob_NilandCommunity Expert
    Community Expert
    February 10, 2016

    If the .XLS documents open cleanly in LibreOffice or OpenOffice Calc, it might be a better tool to export from.

    Calc can trivially Export, as PDF/A, using (*) Selection. That plus control over what would have been the print page size will allow you to consistently export a PDF object sized for the Anchored Frame. The content remains [searchable] text, vector art (if present) and whatever raster art was present, so full quality.

    F
    FieryPantone
    Legend
    February 10, 2016

    not an answer … but I'll watch this thread with interest in case someone explains exactly what "Fit in selected rectangle" is for :-} I'm groping towards a working understanding of how to use this option, but it feels like a very strange workflow.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices