Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell.  A Column Sparkline is best used when you have lots of data points.

You can style them in different colors and add a marker for the High and Low points of your data.  As your data changes so do the Sparklines.

DOWNLOAD WORKBOOK

Sparklines - Columns

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

Benchmark Chart in Excel 2013 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. There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...
XY Scatter Chart: Related Variables When you want to find out whether or not 2 variables are related or correlated, then an XY Scatter Chart should be used to plot the graph. Related variables will show up on the graph as dots that are almost in a straight line.  Examples of variables that have relationships cou...
Copying & Moving Excel Charts I am going to show your three quick ways to copy and move your Excel charts: #1 - COPYING A CHART Click on the chart with your left mouse key and at the same time hold down the CTRL key to copy it and move the chart to wherever you want. When you are done, let go of the ...
Adding Data Labels To An Excel Chart Data Labels make an Excel chart easier to understand because they show details about a data series or its individual data points. Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point. In ou...