Most of the data you summarize in Excel can be divided into categories. In this video, learn how to create column and bar charts that summarize category data effectively.
- [Instructor] Most of the data you summarize in Excel can be divided into categories. In this movie I will show you how to create column and bar charts that summarize category data effectively. My sample file is the column chart workbook, and you can find it in the chapter seven folder of the exercise files collection. In this workbook, I have a single worksheet that contains order count data for four different product categories across three different years. The simplest column chart displays the values for a set of categories.
So for example, if I want to see the batteries, landscape lighting, and light bulbs, and solar panel sales for 2016, I can select cells A three through B six, and then on the insert tab of the ribbon, I can go to the chart group, and I want a column chart, so I will click the column button, and I can select my chart type. You'll notice there are quite a few different types of column charts. Two D, three D, and so on.
The simplest and best chart type I believe, is the clustered two D column. And that is the first one here. You'll notice that you can have three D columns, but to me, a little bit of visual flair, I guess I'll say, is offset by the fact that they're a little bit harder to interpret, so I always prefer to stay with just the standard two D. So I will click the standard two D, and you can see that I have the chart here.
I have the values and they are broken down by category, and if I want to edit the chart title, I can click it, and then select the text, and say by category, and click away. If you want to delete a chart you can select it like I have here, and press delete. You can also create a bar chart from the same data, I'll leave these selected. To do that, once again, select the data, mine is already selected.
Go to insert, and then click the column button again. And then select bar. So let's say that I go for a two D bar chart or clustered bar, click that. And you see I get the same data, except that now that it's summarized as a bar chart. With the chart still selected, I will click delete. If you want to summarize data with multiple categories and multiple series, then you can select the entire set. In this case I will select A two, through D six, so that I have my categories, and then also my years.
Then I'll go to the insert tab on the ribbon, click the column button, and click clustered column. And here you see that I have my categories, I have batteries, landscape lighting, and light bulbs, and solar panels, and they are broken down by year. The blue columns are 2016, red is 2017, and green is 2018. Column charts and bar graphs help you summarize categories of data. If your layout requires that you create a chart, so it's wider than it's tall, consider creating a bar graph.
In almost every other case, a column chart is your best bet.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.