Pie Charts and Sparklines

Uploaded time: August 17, 2022 Difficulty Beginner

Pie Charts and Sparklines

Comment
Download exercise file
0
9.7K Views
Key Points Catalogue

The key points of this lesson

In this lesson, we've introduced two types of charts, the pie chart and sparklines

- Pie charts are suitable for displaying data proportions, and data labels play an important part in it. Clicking the data labels options in the right-hand menu allows us to format data labels.

- The combo of pie charts and doughnut charts can display complex data. A chart with too many colors should be avoided. We can choose the tone on tone, and make the color scheme look more comfortable by adjusting the saturation of the color.

- Sparkline is a handy chart type. Line, column, and win/loss are the three types of sparkline available in WPS. They are all easy to set and are the perfect choice if you don't have a lot of time to make a chart.

You'll Learn

The basics of WPS Spreadsheet.

The most commonly-used batch processing skills for increasing productivity.

Process large data in WPS Spreadsheet.

Master the popular PivotTables to create dynamic reports.

Nest dynamic formulas, including the IF, VLOOKUP, SUMIF, and MATCH functions to impress your leader.

Acquire skills in improving security, sharing, co-editing, and printing files.

Course Content

Start from beginners, from theory to practice, don't worry about learning

You'll Get

  • 300+ Mins Videos
  • 100+ Real Cases
  • 40+ Practice Files

Comments

Seriously, it really helped me a lot. I used to be overwhelmed by the huge amount of data every day, but the spreadsheet has relieved me of the statistical burden!
WPS Office is completely beyond imagination and now I am highly dependent on it for my work, creating test papers, courseware, and slideshows ...... It covers almost everything.

Catalogue