Sparklines

In this task you will create a sparkline chart within a cell. You will add a line sparkline for the open/close data using the ASX Dataset.

This exercise is part of the course

Data Visualization in Google Sheets

Exercise instructions

Move your histogram chart down so that you can see row 27, and in cell A27 type the word Trend.
In C27, enter a formula that will generate a line sparkline based on the data in range C17:C26.
Do the same for cells E27 and F27 (using their respective column data).

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises