How To Create Bar And Column Charts In Excel For Mac


show more Creating bar and column charts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Creating bar and column charts

Charts let you summarize your data visually, making it easier for you to grasp patterns in your data. In this movie, I'll show you how to summarize your data using column charts and bar charts. A column chart compares values across categories. The simplest column chart uses two columns of data: one with categories and another with values for the categories. So here, for example, I have different infusions of olive oil that The Two Trees Olive Oil Company could sell. So, I have Lemon, Rosemary, Mandarin and Jalapeno, and the number of bottles that were sold over the past year in each of those varieties.

If I want to create a column chart to summarize that data, I can click any cell in the data set, and then on the Charts tab of the Ribbon, click Column and then click the type of column chart that I want to create. In this case, I'll just do the standard clustered column. When it appears, you'll see that I have a single column, representing each variety's data. So, we have L...

Creating bar and column charts
Video duration: 5m 26s 6h 32m Beginner

Viewers:

Creating bar and column charts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...