Learn how to use Excel for Mac 2011 to create different kinds of charts—from column, bar, and line charts to Gantt and exploded pie charts—and understand how to decide which type works best for your data. Plus, find out 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. Author Dennis Taylor also introduces analytical tools that will help you make sense of your data and a few dynamic controls that allow you to adapt your charts on the fly. Along the way, he provides tips and tricks to be more productive and efficient.
Topics include:
Creating charts with one click
Selecting the right chart types
Changing chart type or source data
Choosing a chart layout and style
Saving charts as templates
Editing titles, legends, and labels
Adding a data table
Analyzing data with trendlines
Formatting the chart
Customizing different chart types
Creating Gantt and frequency charts
Creating in-cell charts
Moving charts

Lynda Excel for Mac 2011: Charts in Depth