Share via

Settings chart properties for multiple charts and locking aspect ratio on Excel

Anonymous
2020-02-19T10:28:41+00:00

I have a lot of charts on an Excel spreadsheet and need to change the on chart properties and lock aspect ratio on multiple charts.

Is there an easier way of doing this as I need to select every object and change the settings?

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
Answer accepted by question author
  1. Anonymous
    2020-02-19T11:36:30+00:00

    Hi OE,

    Per your description, we do understand that you want to Format the multiple charts in your Excel worksheet at once and you can achieve this by selecting all the Charts in your worksheet> Right-click on one of the chart> Size and Properties.

    I’ve made a video for you by including the detail steps, you can click on this link to download.

    Appreciate your understanding.

    Best Regards,

    Chitrahaas

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-21T12:32:34+00:00

    Hi OE,

    If you need any further help, please feel free to post back to us.

    Thanks,

    Chitrahaas

    0 comments