Microsoft Office Tutorials and References
In Depth Information
Using Sparklines to View Data Trends
12
CHAPTER
EXCEL
Working with Charts
Move a Sparkline Chart
1 Click the cell containing a
sparkline chart that you want to
move.
2 Click the Design tab.
3 Click Edit Data .
The Edit Sparklines dialog box
appears.
4 Select a new location in the
worksheet for the sparkline
chart(s).
Note: The number of cells you select
at the new location must match the
number of sparklines you want to
move.
5 Click OK.
D Excel moves the sparkline
chart(s).
E Any previously obscured data
becomes visible.
Note: To delete a sparkline chart,
right-click it and point to Sparklines.
Then, click Clear Selected
Sparklines or Clear Selected
Sparkline Groups .
TIPS
Can I create multiple sparkline charts simultaneously?
Yes. You can select data on multiple rows; Excel creates a
sparkline chart for each row and treats the sparkline charts
as a group; for example, if you change the chart type of one
sparkline, Excel changes the group.
Can I change the type of sparkline chart?
Yes. Click the cell containing the sparkline
to display the Sparkline Tools Design tab; in
the Type group, click a different chart type.
221
Search JabSto ::




Custom Search