Dynamic min and max with data labels

Tip: Dynamic min and max with data labels

In this video, we’ll look at how to highlight high and low values in an Excel chart using data labels.

This worksheet contains daily sales numbers for a small online store.

I’ll plot the data in a basic column chart.

Let’s say we want to highlight the highest and lowest values by showing these values directly over the bars.

This may seem tricky, but we can build a very straightforward solution using only data labels with a simple formula.

I’ll work through the solution step-by step.

First, I’ll enable data labels.

Duration 
3:14
Author 

Related shortcuts

CtrlEnter

Return

Leave a Reply

Your email address will not be published. Required fields are marked *