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.
There is no denying how quick and easy the keystroke shortcuts are for creating charts instantly in Excel. But the standard way to create a chart using the Ribbon menu system requires just a few mouse clicks, and it does give us the added feature of being able to select the appropriate chart type as we create the chart. So once again we're looking at the data here. Perhaps we're going to be highlighting this data here. This is what we want to see in the chart. The standard way to create a chart in the Ribbon menu system, click Insert and you will see the group called Charts. And we may decide that this is going to look better as a bar chart or line chart. And if you're not seeing the chart type that you're most interested in here, you will see a choice called Other Charts.
And as we click the arrow here, we do see some other types that are not represented there. And the other types are certainly unusual for a lot of us, and it depends upon how you have worked with charts, or what you're interested in doing, but these are the more obscure type, you might say, that have their specialized uses. There is also a button at the bottom All Chart Types. This shows us all, ultimately 73, basic types. There they are. And many, many times when you come to this step you will not have clicked other charts, because you've already determined ahead of time, well, this is going to be a bar chart. And so, for example, if that's the type, we'll click Bar right here, make our choice. Maybe we want to use a clustered bar chart.
We'll just click here, and there we have our chart. So that's certainly not very lengthy. It's easy to use. It is considered the standard way to create a chart. You'll notice here that we didn't say in any way or indicate where we wanted the chart to be, and so the chart automatically goes on the worksheet. Interestingly, in prior versions of Excel, the default location, by way of the key- stroke shortcut, was on a separate worksheet. I think what Microsoft has done here is to recognize that many people prefer to have charts right on a worksheet along with the data, and so the process here, we didn't even stop to think about it.
We saw no choices when we created the chart. We actually put it here on the same worksheet automatically. There is an option, as there has been in the past, with any chart, no matter where it's location, you can easily change the location of the chart, put it on a separate sheet, or put it on a worksheet with the data itself. So creating the chart is simple. It's easy using standard techniques. It's a straightforward process, just a short sequence of commands.
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.