Excel 2010 Charts & Sparklines Quick Reference

ISBN 978-1-936220-42-7
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use charts/graphs and Sparklines features of Microsoft Office Excel 2010. See topics below.

The following topics are covered:

Charts: Inserting a Chart; Creating a Chart Sheet Using the Default Chart Type; Changing Chart Type; Resizing a Chart in the Worksheet; Charting Non-Adjacent Data; Selecting Chart Objects; Adjusting Scale; Creating a Chart with Two Scales; Add, Move or Remove the Legend; Adding a Data Series; Removing a Data Series; Using Tables as a Data Source; Switching Rows and Columns; Adding or Removing Gridlines; Exploding a Piece of a Pie Chart; Adding Explanatory Text; Adding Callouts, Arrows, or Other Shapes; Adding Data Labels; Move, Format, Edit Data Labels; Adding/Removing a Chart Title; Adding an Axis Title; Moving a Title; Using Styles and Layouts; Moving the Chart to Another Worksheet; Adding a Projection or Trendline to a Data Series; Removing a Trendline; Handling Hidden and Empty Cells; Changing the Default Chart Type; Creating a Chart Template; Applying a Custom Chart Type.

Sparklines: Creating a Sparkline; Removing Sparklines; Grouping Sparklines; Changing Sparkline Type; Customizing Sparklines (Adding Text, Highlighting Values); Changing Marker Color; Changing Sparklines Color and Weight; Customizing Axis Settings; Handling Hidden and Empty Cells.


You recently viewed

Clear recently viewed