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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Cycle Charts Cycle Charts in Excel are easy to create using the Smart Art feature.There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle.Here is how you insert a Radial Cy...
Clustered Column Chart: 12 Month Trend An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points.To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values.Below I sho...
Excel Chart Layouts When you create an Excel chart you can choose from 11 different custom Chart Layouts.This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button.From this selection you can show your Chart with or without t...
Change the Axis Units in an Excel Chart Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set.If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in yo...