1 of 1 people found this helpful
Unfortunately, I don't have a quick blanket solution for all your files, but you can do the following for each trend without having to re-create them all:
- If the font size of the legends and scale is the problem, you can change the font on the trend. Right-click and select Format... > Global (You can also edit the legend and scales separately by selecting Legends, Horizontal Scale, or Vertical Scale instead of Global) > Format tab and edit the Font section, such as changing the Size.
- If needed, you can also re-size your trend using either method below:
1. Right-click and select Move/Resize..., then click and drag to select the cells on your spreadsheet that you want the trend to cover.
2. From the Developer tab in the Excel ribbon, click Design Mode, and drag to move and/or resize your trend.
Be sure to save the file after making any change you want to keep. Hope this helps.