View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
chairboy chairboy is offline
external usenet poster
 
Posts: 7
Default Ho do I resize multiple charts?


Hi Shane,

Thanks for your response, but I'm stymied at step one. F5 has no effect.
What is the menu equivalent of F5?

Thanks,
Bob Venezia

"Shane Devenshire" wrote:

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.