Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
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 at the data. And perhaps it's just easier to see because typically it's larger than it might appear on a worksheet. So suppose you've changed your mind about this, its location.
On the Design tab, you see the rightmost button called Move Chart. We can simply click that. And do we want this on a new sheet? We could put in on different sheet, although it's already there. The term here may throw you a little bit. It says, "Object in." Well, that's the terminology meaning the chart is an object. Let's put it in-- I almost want to interrupt and say, "Let's put it on." It will go if we wish it to go, to the sheet called YearData. Now there are other sheets out there. We can certainly click the drop arrow and decide where we want to put it.
Occasionally, you will even see a chart on a worksheet that doesn't have the source data in it. But let's say logically here it might go on the YearData sheet. Before doing that though, let's make a change to it so that we don't confuse it with any existing charts that might be there. Maybe we will just change the chart type of it here. They could be 100% Stacked Column, a choice not too many people use that often, but I'll use it here. And let's simply click the Move Chart button and switch this to be an object on the sheet called YearData.
And as we click OK, something else you will notice at the bottom left of the screen, the sheet that's actually called Chart1 we're now looking at will disappear as we click OK. And on the YearData sheet--this is where we are-- here is that very chart that we moved. So that's pretty easy and fast. I'm going to get rid of it. We don't really need it. Press Delete. But sometimes we do go to the opposite direction and not only can we use that button that's on the right-hand side of the Design tab called Move Chart, we can also do this by way of a right-click.
So on this example here, I've decided that this chart really belongs on its own separate sheet. Let's remove it from here and at the same time create a new sheet. Right-click on the chart area, usually near the perimeter. And by the way, you can also do this on the right border, left border, any of the borders as well. Sometimes when you do this if you happen to right-click in a certain spot, you don't see the choice that says Move. That's what we're looking for. So if we right-click out here in Chart area, we see quite a few choices. Move Chart, and let's just put it on a new sheet.
We're going to put it on the sheet called Chart2. Click OK. So you can easily move a chart to a different location in the same workbook, or you can even move it from its own separate sheet onto a worksheet.
There are currently no FAQs about Excel 2007: Charts in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.