View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Ho do I resize multiple charts?

Hi,

You can do it for all charts on a sheet:

1. Press F5, Special, Objects
2. Right-click any of the charts and choose Format Object
3. Enter a Height and Width on the Size tab and press OK.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"chairboy" wrote:

I have a spreadsheet that contains multiple instances of 2 different charts,
based on templates. Yesterday I opened the spreadsheet and all the charts
were resized so they information no longer fit into the window around the
chart. This happened to all the charts. There must be a way to get them all
resized to the way they were, globally.