ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart sheet in Excel 2007 (https://www.excelbanter.com/charts-charting-excel/230192-chart-sheet-excel-2007-a.html)

Atri

Chart sheet in Excel 2007
 
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

Andy Pope

Chart sheet in Excel 2007
 
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



Atri

Chart sheet in Excel 2007
 
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



All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com