Excel: Charts in Depth

Course details

Excel charts allow you to communicate information with much more impact than raw numbers and are surprisingly easy to generate. Instructor Dennis Taylor shows you how to create different kinds of Excel charts, from column, bar, line and pie to more recently introduced types like Treemap, Funnel, and Pareto. He explains what types of data work best with each so you can decide which type to choose for your specific information. Plus, learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.

Learning objectives
Chart essentials
Fine-tuning charts with design tab choices
Inserting pictures, shapes, and text boxes
Adding shape effects
Applying WordArt styles
Working with chart text
Changing the rotation of chart text
Changing a chart's data source
Printing and sharing charts
In-cell chart alternatives

Concepts

0. Introduction

01 - Add power to your data with charts

1. Chart Essentials

02 - Create charts with shortcuts and standard techniques
03 - Overview of chart types
04 - Choose styles and layouts
05 - Change chart orientation
06 - Move and resize worksheet charts

2. Fine-Tune Your Charts

07 - Add a chart element
08 - Change the location of source data
09 - Deal with empty and hidden cells
10 - Change the default chart type and create a template

3. Adjust Chart Elements

11 - Modify axes
12 - Work with chart and axes titles
13 - Link titles to content
14 - Add and edit data labels
15 - Add a data table
16 - Work with gridlines
17 - Use legends
18 - Add error bars, lines, and up-down bars
19 - Analyze existing and future data with trendlines

4. Format Tab Options

20 - Use pictures as chart elements
21 - Work with shapes and arrows
22 - Add shape styles and effects
23 - Add floating text and text boxes
24 - Work with chart text
25 - Apply WordArt styles

5. Work with Popular Chart Types

26 - Column and bar charts
27 - Line and area charts
28 - Pie charts and doughnut charts

6. Other Specialized Excel Charts

29 - Combination charts
30 - Stock charts
31 - Scatter charts
32 - Bubble charts
33 - Radar charts
34 - Gantt charts

7. New Excel Chart Types

35 - Overview of new chart types
36 - TreeMap charts
37 - Sunburst charts
38 - Histogram chart
39 - Box and whisker chart
40 - Pareto chart
41 - Waterfall and funnel charts
42 - Map charts based on geographic data

8. Change a Chart's Data Source

43 - Create charts from multiple data sources
44 - Use a table as source data for a chart

9. Print and Share Charts

45 - Print charts
46 - Copy and link charts with Word and PowerPoint

10. In-Cell Chart Alternatives

47 - Create graphic-in-cell charts with sparklines
48 - Use symbols and the REPT function for in-cell charts
49 - Create in-cell bar charts with conditional formatting

Conclusion

50 - Next steps