View Single Post
 
Old 03-10-2021, 06:45 PM
LQuinn LQuinn is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2021
Location: Western Australia
Posts: 20
LQuinn is on a distinguished road
Default reset aspect ratio of chart objects?

Hi guys, I have looked but not able to find anything to help in resetting the aspect ratio of chart objects pasted into a document

I'm working on monthly report documents that include a lot of graph objects pasted from Excel and borrowing Paul's code from here - I can process chart objects to fit page width, which works really well! thank you

However I don't have access to chart sources and I find that some people 'squeeze' their graphs, and the squeeze is retained when fitting the chart to page width

Ideally what I'd like is to reset the chart objects back to their original unsqueezed size and then fit to page width

Thanks in advance!
Reply With Quote