Microsoft Office Tutorials and References
In Depth Information
Adding a Sparkline
Note
PivotTable Fields Pane You can modify your PivotTable on the
PivotTable Fields pane, which displays when you select a PivotTable.
For example, you can add and remove the fields analyzed.
Tip
PivotTable Styles To apply a style to your PivotTable, select it, and
choose one of the PivotTable styles on the PivotTable Tools–Design
tab.
Adding a Sparkline
Creating a sparkline—a mini chart that displays in a single cell—is another option for rep-
resenting your worksheet data visually. In particular, a sparkline is a great tool for showing
data trends.
Select the data that you want to represent using a sparkline.
On the Insert tab, select the button for the type of sparkline you want to cre-
ate: Line , Column , or Win/Loss .
In the Create Sparklines dialog box, enter the sparkline destination cell in
the Location Range field.
Click the OK button.
Search JabSto ::




Custom Search