Excel Tricks with Tejraj

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...

In this blog post we will learn to create “Line Chart in Excel”. We will take simple example to create “Line Chart in Excel”. We have listed 05 products: Product A, Product B, Product C, Product D and Product E along with their costs. Now we will see how we can convert this data into “Line Chart” for better data visualization. Just follow below steps: 1. Select the above data which we want to convert into "Line Chart". 2. Go to “Insert” Tab, Select Insert Line Chart command under “Charts” group. 3. We will get further options for selecting Insert Line Chart . Out of these appeared option we have to select “Line” option as shown in below image. 4. We can see that “Line Chart” is now created for our selected data. Changing Chart Style: To change the formatting of our Line Chart, click on the existing “Line Chart” and this will appear two additional tabs on our Ribbon. These tabs are: 1. Design Tab 2. Format Tab Once we click on the “Design” tab, we can see various Chart Styles...