2015
Lynda
Dennis Taylor
4:19
English

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.

Introduction
Welcome
Using the exercise files
1. Creating Basic Charts Quickly
Selecting data to display on a chart
Creating charts with a keystroke or using ribbon icons
2. Understanding Excel Chart Concepts
Identifying chart elements
Selecting the right chart type
Understanding chart terminology
Understanding the Charts Ribbon tab
3. Creating and Adjusting Chart Appearances with Charts Tab Choices
Changing a chart's type
Changing the location of a chart's source data
Dealing with empty and hidden cells
Using Switch Plot for a different view of the data
Choosing a chart layout from the Chart Quick Layouts group
Choosing a chart style from the Chart Styles gallery of 48 variations
Saving a chart as a template for easy access later
4. Using Chart Layout Tab Options
Adding, editing, and removing chart titles and axis titles
Linking titles to content
Adding, editing, and removing legends
Adding and editing data labels
Adding a data table
Modifying axes
Working with gridlines
Analyzing existing and projected data with trendlines
Adding drop lines and up/down bars
Adding error bars
5. Using Format Tab Options and Other Visual Features
Adding color backgrounds to chart areas and other chart elements
Exploring color and line effects for chart elements
Altering chart text styles with fill and line effects
Adding shapes and arrows
Adding floating text and text boxes
Selecting shape styles, fill, and line effects
Using pictures and Clip Art as chart elements
Using right-click and double-click to quickly adjust formats
6. Customizing Specific Chart Types
Customizing column and bar charts
Customizing line charts
Customizing pie charts
Customizing area, stock, and XY charts
Customizing doughnut, bubble, and radar charts
7. Changing a Chart's Data Source
Adding and deleting chart data series
Creating charts from multiple data sources
Adding new data to a chart using a table
8. Specialized Excel Charts
Creating combination charts
Creating Gantt charts
Creating frequency charts
Using Form controls to create dynamic charts
Producing dynamic charts by using filters
9. Printing and Sharing Charts
Printing charts
Copying and linking charts with Word and PowerPoint
10. In-Cell Chart Alternatives
Creating graphic-in-cell charts with Sparklines
Using Conditional Formatting options to create in-cell charts
Using symbols and the REPT function for in-cell charts
11. Chart Manipulation Tools
Changing the location of a chart
Moving and resizing a chart within a worksheet
Converting a chart to a graphic
Conclusion
Next steps

Download File Size:728.86 MB

---