Use Excel charts
A chart is a visual representation of the data in the document. By using elements such as columns (in a column chart) or lines (in a line chart), a chart displays series of numeric data in a graphical format. The graphic format of a chart makes it easier to understand large quantities of data and the relationship between different series of data to analyze the data as well as look for important trends.
Column charts used for looking at a lot of data
Pie charts used for comparing totals
Line charts used for identifying trends
Sparkline or Thumbnail charts are tiny charts in the worksheet that provide a visual representation of data, a new feature in Microsoft Office 2010. Use Sparkline chart to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a Sparkline chart near its data for greatest impact