Excel - Sparklines

---

What is Sparklines in Excel?

Inserting the chart in Excel requires a vast amount of space. Is there a way to add a compact chart to an atomic cell? The answer is yes. Sparklines are minimal charts you can easily add to an independent cell in Microsoft Excel. The massive advantages of the sparklines are that they require less space, their size is adjustable, and you can customize the sparkline to make it appear more beautiful.

Types of Sparklines

Three types of sparklines are listed below −

• Win/Loss Sparklines
• Line Sparklines:
• Column Sparklines

Insert Column Sparklines

Consider the sample dataset that describes the number of road accidents in various cities in different years. The main purpose is to insert the Column sparkline in the G column.

Step 1 − First, go to the "Insert" tab and choose the "Column" options under the Sparklines group.

Step 2 − The other dialog box, "Create Sparklines," will open. Select the range of cells "C4:F4" adjacent to the "Data Range" label. You can specify the location range $G$4 where you want to insert the sparkline. After that, click the OK button.

Therefore, the column sparkline is inserted in the G4 cell.

Step 3 − After that, select the G4 cell, drag the + sign to the bottom right corner, and place it into the G9 cell to insert a similar Column Sparkline in the selected cell ranges.

How to Format a Sparkline in Excel?

When you select the inserted Sparkline, the Sparkline tab will automatically populate in the Excel ribbon.

Various groups inside the Sparkline tab are written below −

Sparkline − You can expand the Edit Data option and modify the data range and targeted location.

Type − In this group, you can alter the inserted Sparkline. For example, if you added the Column sparkline, then you can switch the column sparkline to another type of Sparkline.

Show − It facilitates users' highlighting of the highest point, lowest point, negative points, and first and last points on the Sparkline.

Style − It allows you to change the Marker and Sparkline colors and modify the Sparkline's existing style.

Group − Multiple options like Axis, Group, Ungroup, and Clear are included in the Group. The sparkline axis allows you to modify each sparkline axis's scaling and visibility. You may also group and ungroup sparklines. The Clear options permit you to delete the Sparklines in Excel.

In the previous section, we have learned to insert the Column Sparkline in the selected range of cells.

Lets format the inserted Column Sparkline.

Select the Column Sparkline, navigate to the Sparkline tab, and tick the "High Point" checkbox under the Show Therefore, the "High Point" in the Column sparklines are highlighted.

Click on the Sparkline Style drop-down menu and select "Plum, Sparkline Style Accent 5, Darker 25%" from it

Hence, the formatting of Column Sparkline has been altered.