Sparklines for trend analysis

Please sign up for the course before starting the lesson.

one of the new features from Excel 2010 is Sparklines, which allow you to create mini charts within a cell to highlight trends or changes in data.

In the example below we want to create mini line graphs in the yellow cells (C5 to E5) to show the trend in the relevant columns.

sparklines

To see the full course contents click here.

Back to: Advanced Excel Course > Charting In Excel