Inserting and Customizing Sparklines - Exercise

Contact Us or call 1-877-932-8228
Inserting and Customizing Sparklines - Exercise

Inserting and Customizing Sparklines

Duration: 10 to 20 minutes.

In this exercise, you will practice using sparklines by creating sparklines similar to the examples above.

  1. Open Sparklines.xlsx from your Excel2013.3/Exercises folder.
  2. On the sheet named "Revenue", insert sparklines that look like the following:Insert Sparklines
    1. Note that:
      1. The Vertical Axis Minimum Value Option has a Custom Value of zero (0).
      2. The High Point is highlighted in a different color.
  3. On the sheet named "Stocks", insert sparklines that look like the following:Insert Sparklines
  4. On the sheet named "WinLoss", insert sparklines that look like the following:Insert Sparklines

Solution:

  1. To insert column sparklines on the sheet named "Revenue":
    1. Select cell C3.
    2. On the INSERT tab, in the Sparklines group, click the Column command:Column Command
    3. In the Create Sparklines dialog box, enter D3:O3 in the Data Range and then click OK:Create Sparklines Dialog Box
    4. On the SPARKLINE TOOLS DESIGN tab, in the Show group, click the High Point command:Show Group
    5. On the SPARKLINE TOOLS DESIGN tab, in the Group group, click the Axis command:Axis Command
    6. Under Vertical Axis Minimum Value Options, click Custom Value:Custom Value Command
    7. In the Sparkline Vertical Axis Setting dialog box, accept the default value of "0.0" and click OK:Accept Default Value
    8. Copy cell C3 to cells C4:C6.
  2. To insert line sparklines on the sheet named "Stocks":
    1. Select cell B2.
    2. On the INSERT tab, in the Sparklines group, click the Line command:Line Command
    3. In the Create Sparklines dialog box, enter C2:G2 in the Data Range and then click OK:Create Sparklines Dialog Box
    4. Copy cell B2 to cells B3:B6.
  3. To insert win/loss sparklines on the sheet named "WinLoss":
    1. Select cell D2.
    2. On the INSERT tab, in the Sparklines group, click the Win/Loss command:Sparklines Group
    3. In the Create Sparklines dialog box, enter E2:N2 in the Data Range and then click OK:Create Sparklines Dialog Box
    4. Copy cell D2 to cells D3:D5.
Next