In this tutorial we will learn how to use sparkline in excel. With the help of sparkline differentiation is easy between different candidates. Spark line is small chart for graphical representation of data. Sparkline chart be fit into the cell so it is valuable. Many types of sparklines are available in sparkline group.
use sparkline in excel example:-
For use sparkline in excel you need data. I have results of five students with five subjects.
If you want to insert sparkline chart in row8 so increase size of row8.
First create spark line for John so select data of John.
Now click on insert menu and visit sparkline panel.
Sparkline panel has three types line,column and win/loss. Select line and create sparklines dialog appears. You write in location range text box B8 and press OK.
After pressing OK B8 become as following.
For Charles select data of Charles.
Like John click on insert option and select line now give location range C8.
Repeat same procedure for Bob, Salmax and Addam.Now D8,E8 and F8 become as following.
For changing the design of sparkline visit design menu.
By selection of design the sparkline change according to requirement.
Now sparkline of F8 become as following.
You also can change sparkline line to column. For this first select sparkline and by using design option visit type panel.
After selection of column F8 become as following.
You can change the color of sparklines by using the option of sparkline color.
After selection of required color F8 become as following.
For changing the color of different bars of column chart use marker color option.
After select high point color black then cell F8.
If want to last point be red then select last point and choose color red. After selection cell F8 become as following.
So we used sparkline chart which is required.
Please follow and like us: