Home » Resources » Excel 2007 Tutorial » Moving a Chart to a New Worksheet

You may want your chart to appear on its own worksheet within your workbook. To do this open the chart options ribbon by clicking on your graph. Along with the options you have already used earlier, i.e. chart styles; there is an option on the right called the “move chart location” – click on this:

You will now be asked whether you want to move the chart to another  worksheet that already exists, or to a brand new chart sheet.

A worksheet is the default sheet format that Excel works from (the sheet that you are currently working from is a standard worksheet). If you choose to move your chart to another worksheet you will have to choose which one you want to send it to, i.e. worksheet 2 or 3.

Tip: These other worksheets are available through tabs at the bottom left hand corner of your current work sheet.

Once you have mastered these skills you will be ready to attend our Advanced Excel Course, and really advanced might want to try VBA for Excel.

Similar resources you may like

1. Altering and Moving your chart
2. Moving a Chart To a Chart Sheet
3. Changing Your Chart Layout
4. Changing Your Chart Style
5. Changing Your Chart Type

Tags

chart, Excel, Excel 2007 Tutorial, excel chart, excel training, excel tutorial, Free, microsoft, microsoft excel, microsoft office, resource, Tips, top Tips, training

Share This Resource

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 1:12 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.