Briefly discuss how to best utilize Sparkline charts and how charts should convey necessary information.

What will be an ideal response?

Sparkline charts allow worksheet users quickly to visualize information in a small chart within a cell. The use of multiple Sparkline charts in the worksheet will provide the user with a visual comparison of the various data items for each month. The user, therefore, can see trends for each line item over time and also compare relationships among various line items.

Different chart types convey different messages and are appropriate in different situations. For example, a 3-D pie chart is a good way to compare visually a small set of numbers. Often one or two slices of a pie chart displays as exploded, meaning that the slice appears pulled away from the cart, in order to emphasize the slice to the user. Format chart data points so that the worksheet user's eye is drawn to important information.