1 Reply Latest reply on Jun 6, 2018 2:33 PM by Eddson Sierra

    Graphs

    Iqra Ahmed

      Hello, can I get some assistance on the following questions, please?

      1. Mass changes to graphs – is there any way to make changes to all graphs in a workbook? For example, if we want to change all the font sizes for the axis, or all the font sizes for the labels, all the color scales, etc.
      2. Exporting graphs in a standardized way – is there any way to export images in a batch (i.e. all workbooks)? Is there any way to export images to be a certain size? For example, right now it seems the export depends on my screen size or view. But this can make it difficult if our goal is consistency.
        • 1. Re: Graphs
          Eddson Sierra

          Hi Iqra,

           

          1. Mass changes to graphs. You can copy formatting between sheets [Format at the Worksheet Level]

           

          After you format a worksheet, you can copy its formatting settings and paste them into other worksheets. The settings that you can copy are anything you can set in the Format pane, with the exception of reference lines and annotations. Adjustments like manual sizing and level of zoom are not copied.

          To copy and paste formatting between worksheets:

              1. Select the worksheet from which you want to copy formatting.
              2. Right-click (control-click on Mac) the worksheet tab and select Copy Formatting.
              3. Select the worksheet you want to paste the formatting into.
              4. Right-click (control-click on Mac) the worksheet tab and select Paste Formatting.

           

          2. Exporting graphs in a standardized way. Regarding this, I'm not sure if an option exists to export all images as a batch. But you can print the whole book as a pdf and configure the layout of the printing. Also you can export each sheet as an image file. [Export Views]

           

          One solution might be to put all the grahps in a dashboard as you want it to be (standard measures) and then export that view to a pdf or image file.

           

          Hope you find it useful!

           

          Best!