From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs
Unlock this course with a free trial
Join today to access over 24,200 courses taught by industry experts.
Bar and column charts - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs
Bar and column charts
- [Instructor] Alright, at this point we've gone through the groundwork, we've talked about data vis best practices, gone into inserting, customizing, formatting charts and templates in Excel. Now it's time for the good stuff. Now it's time to actually do some deep dives into each of these chart types. So we're going to kick things off with bar and column charts, one of the most common chart options in Excel and these are commonly used for things like comparing numerical data across categories. The only real difference between a bar and a column is the orientation, so bar charts kind of do a really good job at categorical comparisons and column charts can show the same thing or also introduce some element of time series trending. So data by category, by month, by year, by quarter, whatever it might be. So some examples of data sets that you might visualize with bar or column charts include things like total sales by product type, population by different countries, or revenue by…
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.
Contents
-
-
-
-
-
(Locked)
Bar and column charts8m 49s
-
(Locked)
Histograms and Pareto charts5m 58s
-
(Locked)
Line charts and trendlines5m 16s
-
(Locked)
Area charts4m 41s
-
(Locked)
Pies, donuts, and race tracks12m 4s
-
Scatter plots7m 30s
-
(Locked)
Bubble charts6m 36s
-
(Locked)
Box and whisker charts6m 5s
-
(Locked)
Tree maps and sunburst charts6m 36s
-
(Locked)
Waterfall charts3m 17s
-
(Locked)
Funnel charts3m 42s
-
(Locked)
Radar charts7m 56s
-
(Locked)
Stock charts7m 18s
-
(Locked)
Heat maps4m 41s
-
Surface and contour charts7m 35s
-
(Locked)
Geospatial maps (Power Map)5m 28s
-
(Locked)
Basic combo charts7m 57s
-
(Locked)
Sparklines2m 7s
-
(Locked)
-