Sparkline Tips

Charts

Here are some tips on working with Excel Sparklines.

If you want to… then do this…   
Change the size of Sparkline Change row height or column width
Fill adjacent cells with Sparkline Drag handle in lower-right corner of Sparkline. The data of the additional cells must be in the correct orientation.
Copy and paste fixed Sparkline Select Copy as Picture from ribbon
Copy and paste linked Sparkline Select Copy from ribbon. Select Paste Linked Picture from ribbon.
Save Sparklines to Excel prior to 2010 Sparklines will not save to earlier versions. They are not compatible.
Show maximum Y-axis variation On the ribbon, in Sparkline Tools Design tab, in the Axis group, select Vertical Axis Minimum and Maximum as Automatic for each Sparkline.
Show Y-axis variation of min/max for all Sparkline’s (this may reduce visible variation for individual Sparklines if one Sparkline has a much greater variation than the average.) On the ribbon, in Sparkline Tools Design tab, in the Axis group, select Vertical Axis Minimum and Maximum as Same for All Sparklines.

 

 

Share the power...

Leave a Comment:

Leave a Comment: