How to highlight maximum value in excel chart

There are many reasons why you may be interested in WPS Spreadsheet and its powerful functions. Today's free course will tell you how to highlight maximum value in excel with easy steps.

The trick could be compatible with Microsoft Office Excel. WPS Spreadsheet is the world's leading developer of office software solutions, providing free applications for individuals and businesses to improve productivity.

· Example of highlighting maximum value in WPS Spreadsheet

To highlight max value in a simple column chart. You need to select the data and create a chart first, and then manually change its format.

Let’s look at today’s example. Suppose we want to highlight the peak value of this transcript.

1. Select the data area, go to the Insert tab, and then click Insert Column Chart to create a 2-D column.

2. The data is difficult to recognize. As the scores fluctuate between 70 and 100, let’s adjust the score range.

Double-click the Y-axis of the column. Then click AXIS on the right pane, where you can enter 70 at Minimum to make the data more intuitive.

3. It is clear that John gets the top score in physics. Double-click the highest column, and then go to the FILL&LINE on the right pane. Now, you can choose a color to highlight its value.

4. Transparency and other effects are also available to set at Formatting.

In today’s free WPS Office tutorial, we have learned a simple yet useful way to highlight the maximum value in excel chart. Similar to Microsoft Office, WPS Spreadsheet is avaliable for Windows, PC, Mac, Linux, Android, and iOS devices.

To explore more about WPS Office:

Click here to learn how to draw a column chart 

Click here to see how to use conditional formatting to highlight top three items

Even if you're familiar with Microsoft Word,  which is similar to WPS Writer, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work. WPS Academy can provide free training of shortcuts to generally make things more convenient. Easy to learn Word shortcuts to make your workflow convenient.