Excel Magic: Transforming Data with Line Charts, Column Charts, and Win Loss Charts in Less Than a Minute

This Excel tip is gonna absolutely blow your mind. Have you seen anything like this before? And the best part of it it takes less than a minute to do it. So let’s go. We’re gonna start off with a line chart here. Select cell C4 and then select insert from the ribbon sparkline and lines on the data range. You’re gonna click on this button here and select C6 to C17 and click on. Okay, as you can see, you can see line chart already select all the parameters for the line chart like this and then change the style to show the high and the low. Now let’s do the column and win loss chart. Select cell C4 again and then you drag the cell to the rest of the cell like this and then go sparkline group and ungroup those three chart. And after that select cell D4 and then you go sparkline Types and change it to column and then go to cell C E4 and then go sparkline Type and change to win and then you are done.