Chapter 3, Problem 20P

The following table shows monthly revenue for six different web development companies.

1. a. Use Excel to create sparklines for sales at each company.
2. b. Which companies have generally decreasing revenues over the six months? Which company has exhibited the most consistent growth over the six months? Which companies have revenues that are both increasing and decreasing over the six months?
3. c. Use Excel to create a heat map for the revenue of the six companies. Do you find the heat map or the sparklines to be better at communicating the trend of revenues over the six months for each company? Why?