put chart on seperate tab

Question

In my Excel 2000 I had the option of making a seperate tab for a chart. I don't see that now. How do I do that?

Ihave made charts but they are on top of the spreadsheet I have copied a chart to anew blank tb and then strected it to fit my exra wide monitor.. I would like to just make a new chart that fills the the entire monotor. How do I do that. I do run Win 64 bit but my excel 2007 is 32 bit.

My charts that I alredy have only cover the center of my monitor.

Answer 1

You can still move a chart to its own Chart sheet. Click on the chart to select it and go to

Chart Tools > Design > Location > Move Chart

In the Move Chart dialog select New Sheet.

If you want to create a chart on its own sheet immediately, select the data range and press F11.

Answer 2

You're probably looking for the old Size with window command. That feature was removed in Excel 2007.

If the chart is on a separate chart sheet, you could adjust the paper size (Page Layout > Page Setup > Size) to find a layout that better suits your screen dimensions. Legal should be better, but try a couple. Also minimize Margins.

Of course, if you don't move the chart to a separate sheet, you can select it, go to the Format tab and fill in your screen dimensions in the Shape Height and Shape Width boxes. Or do it manually by dragging.

Answer 3

yes, I can do that but I caanot strech the chart out to full extent of my wide screen monitor.

How do I do that?

Answer 4

How about minimizing the Ribbon (Ctrl+F1) and zooming in? Is that something you can work with?

Answer 5

That did not solve the problem.  I have a 25" monitor, that makes the actual spreadsheet area 8.5 high and 21" wide. But my old charts are 11.5 wide. I want to be able to streach them out to 21". I have to look at 5 years of data at one time. I may try down loading excel 2010 if I have to, but Microsoft sales cannot asure me that wikk solve the problem. Please help.