Chart sheet in Excel 2007

A

Atri

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Odd Excel 2007 behavior: copied chart linked to source sheet 4
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 2
copy chart formatting and chart templates in Excel 2007 4
Adding commands to the Excel 2007 Chart context menu 1
Chart Relative To Worksheet When Copying- Excel 2007 1
How to create a custom line and column chart in excel 2007 1
Pasting chart worksheet as link 2007 2
Excel 2007 - publish chart as htm web page file 1

Top