How-to highlight maximum value in Excel charts? [Quick tip]


Share on facebook
Share on twitter
Share on linkedin

Ever wanted to highlight maximum value in charts? Then this tip is for you.

highlight maximum value in Excel charts

Sample data – Highlighting max values in Charts

Let’s say you have some data like this. If you make a chart, you get the output shown to right.

sample data - highlighting values in charts
Sample Data
chart with no highlighting
Default column chart

To highlight values, just add extra series

Now the fun part begins. To highlight values in Excel charts, we simply need to add extra series with the values you want to highlight. Let’s say you want to highlight the product with maximum units sold. Add an extra column to calculate the values, as shown below.

max column added to data thru formulas

Now, our chart becomes this:

chart with max value column

But we just want one series, not two!!!

While this highlights max value in a different color, it doesn’t quite cut it. We just need to remove the original value.

Or, we could simply overlap one series on top of another, like layering.

Select the chart series and go to format series (Click on the series, press CTRL+1).

Now, set up series overlap to 100% and your maximum value is highlighted.

demo of series overlap - Excel charts

That is all. In just a few minutes and clicks, your chart highlights maximum value.

Another example – Line chart with maximum value highlighted

Here is another example of this technique. This time with a line chart.

max value in line chart highlighted

Apply this idea for other situations too…

You can apply this technique to highlight various kinds of things, like:

  • Minimum values
  • Above average values
  • Values that meet certain target
  • User selection values

FREE Download – Sample file for this tip

Click here to download sample file with few types of highlighted charts. Examine the data, formulas and chart settings to learn more.

Highlight maximum value in Excel charts – Video tutorial

More ways to customize Excel charts

This is one of the many powerful but easy techniques for working with Excel charts. Here are a few of my favorite tips on charting. Check them out to learn more.

Add a reference line to charts

Create info-graphics with shape fill options


Forecasting using Excel charts

Learn more about highlighting values in Excel charts.

Share on facebook
Share on twitter
Share on linkedin

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Chandoo is an awesome teacher

– Jason

Excel formula list - 100+ examples and howto guide for you

100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

IRR and data tables in Excel

Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. In this page, learn how to,

  • Introduction to IRR & XIRR functions
  • Calculate rate of return from a set of cash-flows with XIRR
  • Simulating purchase or terminal value changes with data tables
  • Apply conditional formatting to visualize the outputs
  • Common issues and challenges faced when using XIRR

4 Responses to “How-to highlight maximum value in Excel charts? [Quick tip]”

  1. Jitendra says:

    Hi Thanks for the new tutorial. However I could not make the formula for the additional colum added, work the way showed on the video i.e. when I use the if formula, I could not get the if([unit sold....) to work. I can only get if(C4...)
    Do you define the range or is it excel version issue.

Leave a Reply