Excel for Microsoft 365 Charts & Sparklines Quick Reference

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use charts/graphs and Sparklines features of Excel for Microsoft 365. This guide was last checked for accuracy September 2022. The following topics are covered:

Charts: Inserting a Chart; Inserting a Recommended Chart; Understanding Chart Types (incl. Treemap and Sunburst); Charting Non-Adjacent Data; Quick Chart Using the Default Chart Type; Using Chart Buttons; Resizing a Chart in the Worksheet; Selecting Parts of a Chart; Changing Chart Type; Adding/Removing a Data Series;  Adding an Axis Title; Moving a Title; Adding a Chart Title; Switching Rows and Columns; Using Tables as a Data Source; Adjusting Numeric Scale; Creating a Chart with Two Scales; Adjusting the Legend; Using Gridlines; Adding Explanatory Text; Adding Visuals; Adding and Formatting Data Labels; Exploding a Piece of a Pie Chart; Using Styles and Layouts; Moving the Chart to Another Worksheet; Adding a Projection or Trendline to a Data Series; Removing Trendlines; Handling Hidden and Empty Cells in a Chart; Setting the Default Chart Type; Creating a Custom Chart Template; Applying a Custom Chart Type.

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