Create in cell formatting in Excel – Sparklines

cell formatting

Make you spreadsheets look better. Just add in cell formatting. Insert>sparklines>Line. Select the data range (in this case D3:f3) and you have an in cell line chart. Just copy to rest of the cells. Repeat for in Cell column charts. Really makes you data look much better!

sparklines_1

sparklines_2

sparklines_3

 

Add In Cell Column charts the same way!

sparklines_4

Resulting in:

sparklines_5

Please Login to Comment.