If we want to show our data trend, we can use line charts, however they are usually large. If we want something simple and small, like a chart in a cell, we can use Sparklines.
All we have to do is to select one empty cell, then go to the Insert tab, then go to Sparklines and select the Line Sparkline option. What we will get is a Create Sparkline window, where we have to select a a proper range and check if location is good.(Fig. 1).
After pressing OK and dragging it down, we have trends for other countries (Fig. 2).
If we want to add some markers, we have to open the Marker Color bar and choose proper options (Fig. 3).
After adding markers, sparlines look as follows. If we want to make them bigger, we have two options. We can simply enlarge the cells or we can merge a few cells using the Merge & Center option from the Insert tab (Fig. 4).
Let’s insert a column sparkline there (Fig. 5).
I personally don’t like it too much (Fig. 6).
Let’s change it to line chart again (Fig. 7).
