WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

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

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to highlight maximum value in excel chart

February 18, 2022
2.9K Views

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.

Lets look at todays 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, lets 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 todays 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.

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