Hi!

I often used chart sheets in Excel 2003, but I can't find the same
possibility in Excel 2007. I want a chart to cover the whole
worksheet-window like it did in Excel 2003 (without showing the pivot-table).
Is this possible in Excel 2007? I have tried to use the "Zoom to
Selection"-command, but with no success.

I would appreciate to know if this is possible in Excel 2007.
--
Atri

Hi,

F11 will create you a chart sheet, as it did in xl2003.
If you already have a chart object on a worksheet you can move it to a chart
sheet via the ribbon.
With chart selected use
Chart Tools Design Location Move

Or right click Chart area and pick Move from the context menu

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Atri" wrote in message
...
Hi!

I often used chart sheets in Excel 2003, but I can't find the same
possibility in Excel 2007. I want a chart to cover the whole
worksheet-window like it did in Excel 2003 (without showing the
pivot-table).
Is this possible in Excel 2007? I have tried to use the "Zoom to
Selection"-command, but with no success.

I would appreciate to know if this is possible in Excel 2007.
--
Atri

Hi Andy!

Thanks a lot for your help! It was exactly the help I needed.
--
Atri


Atri skrev:

Hi!

I often used chart sheets in Excel 2003, but I can't find the same
possibility in Excel 2007. I want a chart to cover the whole
worksheet-window like it did in Excel 2003 (without showing the pivot-table).
Is this possible in Excel 2007? I have tried to use the "Zoom to
Selection"-command, but with no success.

I would appreciate to know if this is possible in Excel 2007.
--
Atri