Charts display numerical information colorfully. You can highlight data and press Alt+F1 to create a chart and select from numerous options to change a chart's appearance.
- [Instructor] Creating a chart, which is nothing other than a visual representation of numeric data, is pretty easy in Excel. You can quickly embellish a chart with a variety of visual effects. We're looking at a worksheet called Creating Charts in the workbook 07 Charting. I'd like to represent this information here in columns D through I, as a chart. Most of the time when you've got data, you've got a row on top that defines what's in the cells below it and a column on the left hand side that does the same thing for the rows.
We do have totals here. There's a general rule, but certainly not an ironclad rule, when you're highlighting data, to be shown on the chart, don't include the totals along with the detail. In other words, highlight, for example, just this data here. There's a great keystroke shortcut, if you're in a hurry, Alt + F1, that's using the function key, F1. The data's highlighted. Alt + F1. Immediately, you'll see a chart, on the current sheet. Often, it will overlap your data. All we need to do, is to point near the border of the chart, click and drag this example of it off to the right.
You may have noticed also, there's a new ribbon, it's called Chart Tools. Chart is automatically selected and there are two contextual tabs. A Design tab and Format tab. The Design tab is, by far, the more important one. And your eye, probably, is already attracted to these choices as we slide down here and across some of these various choices. There's a drop arrow off to the right. Now, depending on the different chart types, and there are bar charts and line charts and a lot of others, you will see a whole list of different variations, depending upon the chart type.
Sliding over this one, that one. One of the problems with charting, that some people have, is that every turn it seems as if, there are a lot of choices to be made. So, if you're somewhat indecisive at times, you will be overwhelmed by the variety of choices here. Let's say we like this one. We'll just click it. Of course, we can come back later and make some changes. In the next movie you'll learn about changing the chart type. There are a lot of different kinds of charts in Excel. There's also data off to the left here.
That's surrounded by empty cells, so we can just click inside of it. Another way, to create a chart, the more standard way, Insert tab in the ribbon, off to the right, Recommended Charts. With this approach, Excel's going to give us some ideas about how we might want our data to look. As we slide over the different choices here, we can click to see a larger version off to the right. In the process, you will also be learning, here and there, about different chart types. You may or may not, be using this one in the future, but that's a funnel chart.
This one down here's a pareto chart and so on. Let's say we like the second one. That's what we call a bar chart, cluster bar, to be more precise. Click OK and we've got a chart. And there too, we can make some adjustments. Move it around, look at the variations up above. Not as many as with the column chart, but you'll see some choices there. And here too, we can move this around by dragging inside the border. You can also resize a chart. Point to one of the corners, drag inward. If you wanna retain that same ratio of height to width, hold down the Shift key, let go of the mouse first.
Move that around, put it over here maybe. Another approach to creating charts, you've got your data highlighted, perhaps, you go to the Insert tab. You know ahead of time, in some cases, after working with a feature for a bit, as to which chart type you want. And they're all listed here, amongst these various icons. This particular one allows us to create a column or bar chart. We've got one here for a liner area chart. Let's try a line chart maybe, or let's save, try this a bit. Here too, we slide over some choices ahead of time.
How 'bout that one? That might be a little limiting. Maybe it's not showing us the data in a way that's very dramatic, but nevertheless, sometimes we see a choice. If we don't like it, we'll simply press Delete and it's gone. So it's easy to create a chart. And we can certainly, at various times, also consider, maybe just, a portion of the data. If we wanted to show totals, but not the detail, over in columns D through I, we could be highlighting this data here, let go of the left mouse button. Now, hold down the Control key and highlight this data.
This time, it will go to the Insert tab. We could consider, possibly, a pie chart. Would that work? Well, maybe. Or a 3D pie chart? Lots of options. Over time, you'll probably have a few favorites. If you only use charting occasionally, you probably wanna stick to some of the standard types. More about that in the next movie. So let's say we just go with a, more or less, standard bar chart, but maybe 3D. How 'bout that one? And we can move that around, resize it.
Probably in most situations, you wouldn't have this many charts on the same sheet, but as we're displaying this, it possibly makes sense. So, as we've seen in the various examples here, you can create a chart in several different ways, to quickly display a visual representation of numerical data.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros