Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell.

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, which gives them that much more power.

DOWNLOAD WORKBOOK

Sparklines - Intro

Helpful Resource:

project-management-bundle-excel-ad-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

Add High & Low Points in an Excel Sparkline Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Sparkline pinpoints your strong and weak data points.To enter a High or Low marker you need to click inside your Sparkline which will activate the Sparkline Tools...
Create a Treemap Chart With Excel 2016  Treemap Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month.The tree branches are represented by rectangles, wherein each rectangle's siz...
Clustered Bar Chart: Year to Date Sales If you want to compare your Year to Date sales and have category names (eg. products, business names, channel partners, sales reps etc)  which are way too long, then the Clustered Bar chart is the one for you.In the example below the category names relate to companies and I a...
Create a Pareto Chart With Excel 2016  Pareto Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you the biggest factors in the data set, like seeing which issues are the most common.A Pareto chart, also called a sorted histogram, is a column...