Lynda - Excel for Mac 2011: Charts in Depth
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.
Table of Contents
Introduction1. Creating Basic Charts Quickly2. Understanding Excel Chart Concepts3. Creating and Adjusting Chart Appearances with Charts Tab Choices4. Using Chart Layout Tab Options5. Using Format Tab Options and Other Visual Features6. Customizing Specific Chart Types7. Changing a Chart's Data Source8. Specialized Excel Charts9. Printing and Sharing Charts10. In-Cell Chart Alternatives11. Chart Manipulation ToolsConclusion