A sparkline is a very small line chart that is typically drawn without axes or coordinates. It presents the general shape of the variation (typically over time) in some measurement in a simple and highly condensed way. Sparklines are small enough to be embedded in text or several sparklines may be grouped together as elements of a small multiple.

Making Sparklines

Step 1: Highlight cells B4 through M4 and click the Insert tab. Click the Charts menu.

Step 2: Click the Line option and select the 2D line chart, which is the first option.

Step 3: Click the legend and press the delete key.

Step 4: Click the horizontal axis and press the delete key. Click the Vertical Axis and press the delete key.

Step 5: Click the horizontal grid lines and press the delete key.

Step 6: Resize the chart. Click the chart and drag the handles to the desired size.

Step 7: Create chart for the Expense line and Profit Line: Click the revenue chart and press control D to create a copy.

Step 8: Click the line in the new chart. The referenced data for the Revenue will be highlighted above. Hover the mouse around the highlighted data until you see the cross change to arrows. Click on the arrows and drag down to the next line of data. The Expense data will now be reflected in the chart. Repeat these steps for the Profit data.

Step 9: Add titles to the left of your sparklines.