- No matter how long you've worked with Excel,…you've probably established some kind of familiarity…with the ribbon menu system.…When we work with charts, however,…we do need additional tools…that we will not find in these tabs.…Anytime we click on a chart, what happens?…We have a new ribbon, Chart Tools,…with two contextual tabs, Design and Format.…Earlier versions of Excel had three tabs up here,…and it was quite complicated,…because there appeared to be so many choices.…Actually we have just as many choices now,…but this display is a little bit simpler.…

The two tabs, Design and Format,…appear whenever we click a chart.…The Design tab is the most important,…that's where we make major changes,…for example, changing the Chart Type off to the right.…Sometimes we'll Switch the Row/Column emphasis,…sometimes we'll change the look of the chart,…by way of Chart Styles.…At other times we might change…some of the elements in a chart,…by adding a Chart Element or possibly…changing the layout by way of Quick Layout.…The Design tab has a lot to do…

Resume Transcript Auto-Scroll

Author

Updated

3/1/2016

Released

2/16/2016

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. In Excel 2016, there are six brand-new chart types to learn. 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. 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. Plus, get an overview of the new chart types in Excel 2016: Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box & Whisker.

The training wraps up with lesson on changing data sources for charts and printing and sharing charts.

Topics include:

Identifying chart elements

Selecting the right chart type

Creating basic charts

Creating sparklines

Styling charts

Moving and resizing charts

Modifying axes

Adding labels and gridlines

Analyzing data with trendlines

Inserting pictures, shapes, and text boxes

Customizing column, bar, line, and pie charts

Creating Gantt charts and other specialized Excel charts

Changing data sources

Printing and sharing charts

Skill Level Intermediate

4h 36m

Duration

517,558

Views

Show MoreShow Less

Q: This course was updated on 03/01/2016. What changed?

A: We added one tutorial about the new Funnel chart type in Excel 2016.