Post by Keitht on Jan 21, 2016 22:03:46 GMT -5
How To Create Sparklines
In XL 2010 there are 3 ways to create sparklines to add that little bit of panache to your dashboard reports:
1 Set up the data and create a line graph in the usual way. Then remove all extraneous item and embellishments (titles etc). Finally resize (to sparkline dimensions) and drag to the required location
2 Use the RibbonFirst make sure you are in a compatible xl file, then select your datarange and goto Insert / Sparklines. Check the range, select the output range, press OK and presto, there it is.
Notice a range of sparkline tools appears on the ribbon for editing and formatting:
3 Or Go external with an excel addin.