ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   New Sheet for Graph (https://www.excelbanter.com/charts-charting-excel/224467-new-sheet-graph.html)

Kings Canyon

New Sheet for Graph
 
In the new Office 2007, how do you automatically get the graph to appear in a
new sheet and not laying on top of the data? In the old version of
Microsoft, you could choose to make a new sheet. I don't see that option now
in 2007.

Shane Devenshire

New Sheet for Graph
 
Hi,

1. Select your data and press F11.

or

2. If you already have a chart, select the chart and choose Chart Tools,
Design, Move Chart (far right on the ribbon).

3. Right-click the chart and choose Move Chart
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Kings Canyon" wrote:

In the new Office 2007, how do you automatically get the graph to appear in a
new sheet and not laying on top of the data? In the old version of
Microsoft, you could choose to make a new sheet. I don't see that option now
in 2007.



All times are GMT +1. The time now is 06:45 AM.

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