I have reports I do every month, I use Word for them. I use Excel to generate charts which I link into Word so that I can easily update them by just updating the data in Excel. Works great. But I have this one report which gives me a headache.
In this particular Word report I have two charts per page. I shrink them down to 70% so that they can both fit nicely together. When I start working on a new month's report I just save the previous month's Excel and Word files as the new month and update the links. Only problem is when I do this all the charts in the new Word doc go back to being sized 100% and I'm left with a mess moving them all back into place. Sometimes I even lose pages if some of the charts pile on top of each other.
Does anyone know of a way to fix this problem? Is there a step I'm missing that will keep my charts sized at 70% when updating from month to month?
Thanks in advance for any help,