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.
The colors that we see in the column chart to the right of the data here come automatically, and for many of us, myself included much of the time, they're just fine. I don't worry about them too much. Keep in mind that if you'd like to fine-tune a chart, you could easily change any one of these simply by right-clicking on any of these columns here, Format Data Series, and way too many choices for a lot of us. Let's do talk about a feature though that's readily available and for some people is ideal, particularly if they don't have the time to make a lot of design changes.
These are actually called style adjustments. Anytime you have selected a chart, if you go to the Design tab, you will see a large group called Chart Styles. There is drop arrow on the right-hand side. 48 choices. If you are an indecisive person, you are going to have some problems with this. A lot of choices here. The default is right here, the upper row here. It's the second choice. And either experiment--I like this one. It's sort of pseudo-three dimensional. Got some surface to it. I like that.
And I kind of question why they have some these. If all these bars have the same color, almost the same color here, for any of us who have difficulty in discerning the differences between colors, I don't think that's such a great chart. But they're here and depending upon chart type, you will see similar choices. So if, for example here, on the Design tab if I change the chart type here to be anything else--and we mean anything else, maybe I'll make it a stacked bar here, click OK-- we see what's happened there and go to the choices, and now there are all our chart choices.
Click there, and so on. But it is quick, it's fast, it's easy. And one thing that will change the way you will proceed with this could be your choice of what's called a theme. Now that's perhaps the stuff of a different course, although it is related to Excel formatting. But let's just point out here that on this worksheet-- let me zoom back a little bit-- there are some other charts. And if we were to change the theme by going to the Page Layout tab in the Ribbon-- left-hand side, choose Themes-- as we slide over some of these choices, you can begin to see some changes in the background.
I think to see this a little bit better here, I'll zoom in a bit more so we can keep our eye on some of these charts. We don't have to see them all necessarily, but once again, on the Page Layout tab, choose Themes, and now I have the mouse hovering over Equity and then Flow and then Foundry and so on and so on. We see what's happening here. I kind of like this one maybe. I don't like that one. I like that one and so on. Now notice how all the charts are changing. So this has some impact.
If I go with Solstice here, not only am I making a change to the colors, but notice the font, particularly in the chart just to the right. It's a different font than we're used to seeing too, and look at the data itself. So that has worksheet-wide implications here as we make these changes. If I go back to the chart now and then on the Design tab look at the Chart Styles, we see what's happening here. And once again, we are seeing a similar kind of layout but obviously different colors than we saw before. So you can imagine the possibilities here and for some people, they get lost in a hopeless tangent here because they can never decide what exactly it is they need.
Easy to get to, 48 different style options, and it does depend upon what you have chosen as a theme. If you stick with the standard theme, I am going to go back to that since I do prefer it and it raises few questions during presentations anyway. Come back to the Office theme, and there we are.
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.