When you have  a large data set with positive and negative numbers, a great way to visualize the trend is to add a Win/Loss Sparkline next to your data.

That way you or the reader can easily spot the trends and patterns.

To enter a Win/Loss Sparkline in Excel you firstly need to follow these steps:

1. Select your data;

2. Insert > Sparklines > Win/Loss

3. Select the range that you want to insert the Win/Loss Sparklines (this is usually the next column after your data ends) and press OK

4. You can change the Style of the Sparkline by clicking in the Sparkline (which activates the Sparkline Tools Tab in the ribbon) and then choosing the Style drop down box

5. To change the negative color you need to select Marker Color > Negative Points > Select Color

DOWNLOAD EXCEL WORKBOOK

Sparklines Win-Loss

HELPFUL RESOURCE:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Custom Chart Labels Using Excel 2013 In a previous blog post we created a Benchmark Chart using Excel 2013.  We are going to extend this concept and add some cool looking custom chart labels to make our chart more informative. View the Benchmark Chart using Excel 2013   DOWNLOAD EXCEL WORKBOOK STEP ...
Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt. To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...
Thermometer Excel Chart Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own. A Thermometer Chart gives you a good view of the percentage of progress made on your project, budget etc. We are going ...
Benchmark Chart in Excel 2010 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. I will show you how to do this using Using Excel 2010. DOWNLOAD EXCEL WORKBOOK STEP 1: Enter your data into three ...