Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
Sometimes you need to expand a chart to include data that you didn't originally have, or you didn't think you needed, and then you want to change the chart. You can do this pretty easily with just standard copy/paste techniques. In this worksheet, we currently have no chart, but let's create one based on the data from January through December here, Domestic, Europe, Asia, just the data here. Let's not include the Totals to the right. And a quick way to create a chart is Alt+F1 right here on the worksheet. So we got a fairly decent-looking chart, no titles in there just yet.
Then it occurs to you that maybe you would like to put in averages. We don't have any average data there just yet, so let's put in the word 'Average' here in cell F4 and then, below this for each month once that's in place, we'll just highlight all of these and use the function =average (. And we need only highlight cells B5 through D5. And then since we have got all of these cells selected ahead of time, we can just press Ctrl+Enter to get those formulas in place, maybe adjust the title a little bit here, right-align it, make it bold.
Let's add this data to the chart. Now whether it was there or we just created it makes no difference. We simply want to take this data and do a copy paste. So I'll right-click Copy on the data, and we are going to paste it. And you might think you could just paste it right in the body of the chart, say in the plot area, but if you try that, there's no paste option. Do this in the chart area, that area along the perimeter of the chart where you have got a lot of white space, say here. So I am going to right-click on the white space here and paste.
And we now see that the averages are here, along with the legend update. Now that might not be the best choice, so in this situation what might work better here is to take the average series, now I just clicked on it once here, and change the chart type of that. So on the Design tab in the Ribbon up above, choose Design, the leftmost button, Change Chart Type and let's pick one of our line option choices, perhaps the one that has markers on right here. You can double-click it to make it slightly faster.
So we've not only added data to the chart, but we have changed the chart type of the added data, and you can do that wherever necessary. You can copy data from different parts of not only this worksheet, but from other worksheets as well, to make changes or adjustments to a chart. Sometimes the reverse is true. Now this might make our average seem less important, but sometimes you will say let's just take out the data. So if I didn't want Asia here and maybe I change my mind in the process, but I am clicking the color for Asia, and all the Asia columns are selected, I could simply press the Delete key and Asia disappears from the chart.
Now, that doesn't change the average, so this would be misleading right now, unless I change the formula. But it is to point out that you can delete as well as add. So I am going to press Ctrl+Z, meaning undo, to go back to where we were. So you can copy and paste data from any location into a chart.
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.