Changing the location of a chart


show more Changing the location of a chart provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Changing the location of a chart

When you create a chart with the so-called quick method, the function key F11 that creates a chart, it puts it on a separate sheet. You may want to move that chart from a separate sheet back to, or onto, a different worksheet. And similarly, in reverse order, if you have a chart on a worksheet, like the example here to the right of the data, if you'd like to remove that chart from here and put it on its own separate sheet, you can do that as well. So at anytime you can make a change. At different times you may change your attitude about where a chart really belongs.

Let's suppose we select some data here and quickly create a chart on another sheet with the shortcut F11. If you keep your eye on the sheet tabs at the bottom, after pressing F11, we will see a new sheet to the left of this. There it is. It's called Chart1, and there is that chart. And again, the advantage of working with a chart on its own sheet is that you're strictly focused on the chart. You're not looking...

Changing the location of a chart
Video duration: 3m 33s 3h 36m Intermediate

Viewers:

Changing the location of a chart provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...