From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating a column chart

Creating a column chart - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Creating a column chart

“

We can create column charts with just a few clicks. And Excel has many different types of charts and many variations of them. But when you learn how to use column charts, you can use the same techniques for other charts as well. Well, let's take a look at this worksheet. It has pretty typical type of data that you might want to chart. So to create the chart, we have to select the data first, because remember, Excel doesn't know what we want. We have to tell Excel what we want. So let's select from A4 down to D11. So we are selecting the column headers for State and the three quarters and the data for all our States. The important part is we are not selecting the Total column and we are not selecting the Total row. When you create a column chart, you don't want to select your totals, because then you will double the amount of data that's in your chart and your chart just won't be right. So now that we have it selected, we insert a chart. Well, because we are inserting a chart, we go up…

Contents