Charting Syllabus

Charting

This course covers Charting and consists of 26 topics.

Combo and Secondary Axis Charts – In this video we create Combination charts and Charts with a Secondary Axis.
Handling Missing Data – In this video we show options for handling missing data in charts.
Handling Hidden Data – In this video we show options for handling hidden data in charts.
Adding Pictures to Column Charts – In this video we show how to add pictures to your column charts.
Data Labels – In this video we show how to add Data Labels to a column chart.
Data Tables – In this video we show how to add a Data Table below a column chart.
Labels From Cells – In this video we show how to label points with labels based on cells in Excel. This is for users of Excel 2013 and Excel 2016.
Creating Icon Sets – In this video we show how to use the WINGDINGS3 font to create customized Icon sets.
Band Charts – In this video we show how to create a Band Chart to summarize how inventory moves between lower and upper control limits. We also show how to create and use Chart Templates.
Thermometer Charts – In this video we show how to create Thermometer charts that summarize monthly performance against a target.
Dynamic Chart Labels – In this video we show how to create Chart Titles and Series Labels that dynamically update as we change our spreadsheet inputs.
Check Boxes and Chart Dashboards – In this video we show how to use Check Boxes to control which series show in a chart.
List Boxes and Chart Dashboards – In this video we show how to use List Boxes to control which series shows in a chart.
Spinners – In this video we show how to create a Spinner that enables you to change the values of any number of spreadsheet inputs by clicking on your Spinners.
Gantt Charts – In this video we show how to create a Gantt Chart that monitors completion times of project activities.
Dynamic Histograms – In this video we show how to create a dynamic histogram that updates automatically when new data is added.
Charts Based on Sorted Data – In this video we show how use a column chart to summarize sales in 50 states where the columns are listed in descending order of sales.
Adding Conditional Colors to a Chart – In this video we show how to color monthly sales green when we have a good month, yellow for a typical month, and red for a bad month.
Waterfall Charts – In this video we show how to create Waterfall Charts with Excel 2013.
Creating Charts With GETPIVOTDATA – In this video we use GETPIVOTDATA and the Excel Table feature to create dynamic charts based on a PivotTable.
Pareto Charts – In this video we show how to create Pareto Charts in Excel 2013.
Vertical Line – In this video we show how to place a vertical line in a chart that moves when the chart is relocated.
Radar Charts – In this video we use Radar charts to summarize employee attributes on multiple dimensions.
Bubble Charts – In this video we use a Bubble Chart to summarize sales in different countries on three dimensions.
Sparklines Part One – In this video we use Sparklines to visually summarize daily customer counts in different bank branches in a single cell for each branch.
Sparklines Part Two – In this video we use Win Loss Sparklines to visually summarize week by week NFL results.
Learn More