From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating a column chart - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.