Introduction

• Why Create a Chart?
• Anatomy of a Chart
• Choosing the Best Chart Type
• Selecting Data

Creating a New Chart

• Creating an Embedded vs a Separate Chart
• Adjusting an Embedded Chart

Modifying the Chart Type

• Changing to Another Chart Type
• Changing the 3-D View

Changing Chart Element

• Activating and Selecting Chart Items
• Changing Fonts and Value Axis Settings
• Changing Colors and Patterns
• Working with Pie chart
• Creating an open-high-low-close line chart

Rearranging Chart Data

• Plotting Data series in Rows instead of Columns
• Plotting Data series in Columns instead of Rows
• Reversing the Plotting Orderof categories, values or series
• Changing the Plotting Order of Data Series

Adding Text and Titles

• Adding Title to a Chart and Axes
• Adding Data Labels
• Adding "unattached" text to a Chart

Adding and Removing Data Series

Combination Charts

• Combination with a single y-axis
• Combination with a secondary y-axis

Setting the Default Chart Type

• Changing the default chart type
• Using the selected chart as the default chart type
• Saving a custom chart type to apply to other charts

Creating a "Progress Chart"

Choosing the Right Chart Type

• Area Chart
• Column Chart
• Bar Chart
• Line Chart
• Pie and Doughnut Charts
• Stock chart
• XY Chart
• Bubblechart
• Radar Chart
• 3-D Surface Chart
• Cone, cylinder and pyramid charts
• High-Low-Close Line Chart