Goodbye

Upon completion of this course, you might want to check out some additional Excel…courses at lynda.com. For a review of all the basics, go to…Excel 2013 Essential Training. You might also want to check out other…Excel 2013 courses, such as Advanced Formulas and Functions, Power Shortcuts,…and Pivot Tables. All suitable for Excel users who want to…improve their efficiency in using this powerful software.…And you'll find additional courses there as well.…So check back from time to time for updates and new courses.…

Thank you for watching.…

Resume Transcript Auto-Scroll

Author

Released

8/6/2013

Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. 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.

Topics include:

Selecting the right chart type

Choosing data to display as a chart

Creating charts fast with the Quick Analysis tool

Choosing a chart layout

Changing the location of the source data

Dealing with empty and hidden cells

Moving and resizing charts

Adding data labels

Analyzing existing and future data with trendlines

Adding shapes and arrows

Working with column, bar, line, pie, and area charts

Working with specialized chart types: Gantt, Pareto, and Frequency charts