Fix Graph Size

Tagged: 

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #57435
    AvatarAndrew
    • Topics: 1
    • Replies: 2
    • Posts: 3

    I have a template worksheet with 6 graphs is there a way to set unifrom size for all graphs?

    #57437
    DarrenDarren
    • Topics: 55
    • Replies: 461
    • Posts: 516

    Hi Andrew,

    Use the cloning feature to equally size tiled charts, which can then be saved as a Page Layout. See the video here:

    https://www.optuma.com/videos/how-to-equally-size-tiled-charts/

    #57451
    AvatarAndrew
    • Topics: 1
    • Replies: 2
    • Posts: 3

    Hi Darren,

    Thanks for the video which works but when I change a field on the cloned graph they all change to 1 day like the original and  I want 1 day, 1 week and 1-month graphs?

    #57453
    DarrenDarren
    • Topics: 55
    • Replies: 461
    • Posts: 516

    Ah sounds like the chart you cloned is using a Chart Layout, so if you change the timeframe on one it’s linked to the others via the layout, so all charts using that layout (even in other workbooks) will also change.

    To fix, you would either need to clone a chart that doesn’t use a Chart Layout, or create a layout for each timeframe and apply it to the cloned charts.

    #57473
    AvatarAndrew
    • Topics: 1
    • Replies: 2
    • Posts: 3

    Thank you, the graphs look so much neater now, OCD sorted out, cheers.

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close