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.