If you use sparklines Excel has some excellent features. Use Excel sparklines to analyze trends in your data.
By default, each sparkline is scaled to fit the maximum and minimum values of its own data. This allows it to fill the entire cell, no matter how high or low the values are. However, it has a downside: If you are trying to compare several sparklines, you won't be able to tell at a glance which have higher or lower values. The solution is to make the display range the same for all of the sparklines.