On the "Adult Program" worksheet, insert a Column sparkline for each sport that shows the enrollment for the past five years.

Explanation/Reference: 1. On the "Adult Program" worksheet, select the area you want the sparkline to be inserted. 2. On the Insert tab, in the Sparklines group, click Column. 3. Enter the range of cells in the Data Range box, in this case A10:A19. OR 1. Select the range of…

Create charts and objects

Question

On the "Adult Program" worksheet, insert a Column sparkline for each sport that shows the enrollment for the past five years.

Explanation

Explanation/Reference:

On the "Adult Program" worksheet, select the area you want the sparkline to be inserted.
On the Insert tab, in the Sparklines group, click Column.
Enter the range of cells in the Data Range box, in this case A10:A19. OR
Select the range of cells by temporarily collapsing the dialog box and manually selecting the cells.
Click OK and the Sparkline Tools will appear, the Design tab can be used to customize the sparklines. References: https://support.office.com/en-us/article/analyze-trends-in-data-using-sparklines-b6e0f79cf-a0e3-471a-a459-873614413ce1

Topics

#sparklines#column sparkline#data visualization#worksheet

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice