- [Instructor] Let's create some charts
to go along with this data
so we can visually see how that data is represented.
To get started, click and drag
and highlight any data that you want represented by a chart.
Be sure to leave off any totals,
as that can wreak some havoc in your data.
Once it's selected, you have a few options.
You can change to the Insert ribbon tab,
and, right in the middle,
you can hover your mouse
over a particular type of chart
if you know exactly what you're looking for.
However, with this data selected,
Excel realizes that it can become a chart.
There's a button called Quick Analysis
that pops up on the bottom right-hand side of your data.
If I click this button, here's where I can see
where I can enter tables, totals, and charts.
I'll click on Charts.
And if I hover my mouse over the data,
I can see what it's going to look like.
I'll click on one,
and instantly I get a clustered column chart.
Now, this chart works just like an image,
meaning, I can drag it around anywhere on my spreadsheet.
I can make it larger or smaller
by dragging and clicking on the corners.
I can make it bigger.
So right away I can move it around.
But there's a lot of other interactions
that I can do with this chart.
To the right of the chart,
I can click the plus sign
to add or remove elements
like legends and trendlines and axis titles.
I can click the paintbrush
to set a style and color scheme for the chart.
And I can also use filters to edit data points.
At any time when you select a chart,
two new ribbon tabs appear.
The first one is Chart Design,
and you can click on Chart Styles in the middle
to see different ways that your data is represented.
In fact, you can hover your mouse over each one
to get a preview
of how it's going to change the way the chart looks.
This is just changing it visually.
It's not changing the data in any way, shape, or form.
It's just making it look different.
You can also change the colors of your chart.
On the right-hand side,
you can switch the row and column data,
and you can also change the data range
that's selected for the chart.
Finally, I can click Change Chart Type.
I don't like this particular clustered column.
For example, I have a line chart, pie, bar.
There's so many different types of chart designs.
Excel is so powerful,
and you might want to go through
and see which one will work best to represent your data.
In fact, even with this clustered column selected,
I can still click across and change the way it's displayed,
for example, a 3D stacked column.
Let's go to a different chart.
This one has percentages on it.
I think this would be great as a pie chart.
I'll select the data.
I'll click Quick Analysis again.
Select Charts.
And, this time, I'll select a pie chart.
And, again, I can move this around anywhere.
I can resize it
and change the way it looks in the Chart Design tab.
If I hover my mouse over the chart styles,
it gives me a lot of different choices.
Many of these are PowerPoint ready,
ready to be brought right into a presentation.
This looks great.
We'll do one more.
I'll select the data.
And put it in a chart.
But, this time, I'm going to choose More Charts
because I think that this would be great as a line chart.
It's going to show me some recommended charts,
but I can change that.
I'm going to click All Charts,
and, this time, I'll choose line.
I'll click OK.
And here's my chart.
Now, again, this is your chart.
You can do anything you want.
For example, I can click inside the chart title
and change the text.
I'll put in my heading.
I can change the legend.
And if the data doesn't look right to you,
you can always change it.
Some data looks better
and is more readable with certain chart types,
so you can always go through and change the chart type
to find the proper chart type
that's going to correctly tell the story of your data
that you're looking to tell.