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.

Helpful Resource: