Fix Graph Size

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

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/

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?

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.

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