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 Order of 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
- Bubble chart
- Radar Chart
- 3-D Surface Chart
- Cone, cylinder and pyramid charts
- High-Low-Close Line Chart ??
|