Excel Tricks with Tejraj

In our previous blog post we have learned to insert Sparklines in excel . Now, we will go little advanced in this blog post and learn to customize the Sparklines. If you have not visited our blog post on inserting Sparklines in excel then please click here before proceeding for this blog post, as we are going to use the same data which we have used previously. We have crated 03 types of Sparklines: Line, Column and Win/Loss as shown in below image. To customize Sparklines in excel, we have to first enable the “Design” tab on the ribbon. Design tab will get enabled if and only if we click on the Sparklines. If we click on any portion where Sparklines are not created then Design tab will get disabled. Once we click on the “Design Tab” then we can see the commands which are divided in various groups. In this blog post of “Customizing the Sparklines”, we will see all the commands “Show Group” which are highlighted with Pink color and the commands to change the “Sparkline Color” and “Mark...

In this blog post we will learn to insert Sparklines in excel. Sparklines are also called as mini charts which we can insert in a single cell . First of all, we should know where we can find the Sparklines command in excel screen . It is available in Insert tab as shown in below image. There are three types of Sparklines we can insert in excel as listed below: 1. Line : These are similar to Line Chart , the only difference is that we can insert it in a single cell. 2. Column : These are similar to Clustured Column Chart ,the only difference is that we can insert it in a single cell. 3. Win/Loss : These are similar to Column Sparklines but the difference is that magnitude of this Sparklines does not change according to the selected data. It is recommended to use this Win/Loss Sparkline for showing binary output or the data which shows only two types of output such as Win or Loss. We will now learn to insert all these three types of Sparklines with the help of below data. This is dummy d...