Imagine you have result sheet for your students over the last 5 years and want to create a chart in Excel, which takes time. In that case, you are thinking if only there were some small mini-charts in a single cell. Well here is the solution.
What are sparklines?
Unlike charts on an Excel worksheet, sparklines are not objects — a sparkline is actually a tiny chart in the background of a cell.
Why use sparklines?
Data presented in a row or column is useful, but patterns can be hard to spot at a glance. The context for these numbers can be provided by inserting sparklines next to the data. Taking up a small area, a sparkline can display a trend based on adjacent data in a clear graphical representation. You can quickly see the relationship between a sparkline and its underlying data, even when your data changes you can see the respective changes in the sparkline immediately.
Case Study: In this example, we will use a database of an electronics shop that contains profits from each product for the last 5 months. We want to see the trend of profit of the particular product beside it. How can we do this?
Answer: Using Sparklines!
Step #1: Create a table in an excel sheet. In the cells of column G we will create sparklines based on the data in the adjacent cells.
Now, use this technique to convey more information using less space.