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.
One of the problems that some people have in working with Excel charts is the tremendous wealth of possibilities for altering charts. There are so many options, and nobody really counts, but it's in the millions. And one of the ways that you will begin to understand charts a bit better, even before you created them, suppose you're looking at a worksheet like the one here called chart data. When you click on a chart the Ribbon menu system at the top of the screen, brand-new in Excel 2007, changes in a significant way.
As I click this middle chart on the screen here, the one just to the right of the data, keep your eye on the Ribbon up above and what happens? We see--and the terminology here, by the way, will vary if you're looking this Excel book or that book. It does vary somewhat. A lot of books will say there is now a new Ribbon called Chart tools. I think it's little more accurate to say there are three new tabs on the existing Ribbon: Design, Layout, and Format. And in this course, we'll be using many, many different features from each of those tabs, and it can be a bit overwhelming at first. Think of it sort of in this way, though.
The most important choices related to charts that you'll see are on the Design tab, and as I click this, all the choices that we see here, particularly the one on the left for changing chart type, and as we'll see some of the others here, are very important in the way that you use charts. Once you click Layout, you'll begin to see, this is where a lot of the fine- tuning is going to be done when you need those features. And the Format tab, perhaps less important most of the times in Layout, has a lot more to do with the actual visuals, the colors.
And again, we're not going to go through every single option here. But every time you click on a chart, you will see the term Chart Tools above the Ribbon and then these three tabs: Design, Layout, and Format. And the very structure of this course focuses on these three tabs, in that order, too. And anytime you're creating charts, keep in mind, you will see these. If I click outside of a chart, back on the worksheet, watch the Ribbon change into its more typical look, where we have the Home, Insert Page, Layout tabs that we normally see.
Click on the chart, we see the other three. So by recognizing the major kinds of grouping that occur on the Design, Layout, and Format tabs, this is going to simplify and give some sense of order to the way that you handle charts.
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.