Sizing Excel charts

[Aurora]

I am using Excel 2003
I receive several (approx 40 charts) each month, from various people, that I
have to copy and put on 1 spreadsheet. I put 1 chart on each worksheet
giving the name of the chart on the tab. When I copy the chart (only the
chart - not the data), it comes over smaller then my computer screen. But I
want the chart to be the whole screen size - Kind of like in power point when
you go to slide show to view all of the charts in full screen. Is there a
way to do this in Excel?

Aurora

 

[Jon Peltier]

Can you put the chart onto its own sheet? Chart menu > Location > As New
Sheet. Then go to Tools menu > Options > Chart, and check Chart Sizes with
Window Frame.

- Jon