WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Create simple and intuitive mini charts

Uploaded time: October 19, 2021 Difficulty Intermediate

Create simple and intuitive mini charts

Create simple and intuitive mini charts

The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.

In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.

1. Click the Insert tab.

2. Click the Line buttons.

3. Now a Create Sparklines dialog box will pop up.

4. Select cells B3:J3 as Data Range.

5. Select K3 in Location Range.

6. Then click OK.

7. Finally, use fill handle and pull down to create mini line charts for other sales data.

We can check the High Point and Low Point to mark the highest and lowest points in the mini line chart. Also, we can check Markers to mark all the data points.

Below are some preset styles of a mini line chart. If we can't find the style we want, we can click the Sparkline Color or Marker Color drop-down button to set up our own line chart colors.

We can also switch the type of mini chart, WPS Office has provided us three types of mini chart, namely mini line chart, mini column chart, mini Win / Loss chart. If we want to delete the mini chart, just click the Sparkline Tools tab, and then click the Clear button.

What should we do if we want to use other types of the mini chart to present data?

Let's turn to Sheet2. We can make a mini pie chart to show data trends.

1. Select C3: D3 cell range.

2. In the Insert tab, click the Insert Pie or Doughnut Chart drop-down button.

3. Then select the Pie option.

4. Now a pie chart will pop up. We can select the chart title and legend, and press Delete.

In CHART OPTIONS, click on the orange color part to change the color. We change it to gray to facilitate our data observations.

1. We click on the chart, check No fill in FILL.

2. Check No-line in LINE.

3. Now our pie chart becomes transparent. Drag the control dots on the outside of the chart.

4. Adjust the size to fit the E3 cell height.

5. Then place it in the E3 cell.

1. Copy a pie chart.

2. Place the pie chart within cell E4 below.

3. Then click on the Select Data button and change Chart Data Range to C4: D4 cell range.

Similarly, we can copy another pie chart. Then change the cell range to C5: D5.

We found that the three pie charts that we just created are not aligned.

Press and hold the Shift key to select the three pie charts from bottom to top. Now click the Align Center button to align the three pie charts.

Above are some methods for creating mini charts. Did you get it?

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.