This worksheet contains daily sales numbers for a small online store.
I’ll plot the data in a basic column chart.
I’ll work through the solution step-by step.
First, I’ll enable data labels.
Now we can clearly see the sales values for each day.
However, we only want to show the highest and lowest values.
An easy way to handle this is to use the “value from cells” option for data labels.
you’re able to find this setting under Label options in the format task pane.
Then I need to pick the new column.
When I click OK, the existing data labels are replaced by the labels I typed by hand.
So that’s the concept.
Now we need to make the solution dynamic, and pull in the actual values.
I’ll start by adding the max value.
To make the formula easy to read and enter, I’ll name the sales numbers “amounts”.
And back in the chart, we now have a data label that shows maximum value.
Now I need to extend the formula to handle the minimum value.
I could add another nested IF, but using the OR function is a bit more compact.
Otherwise, return an empty string.
Now the formula returns both min and max values, and the chart shows these values as data labels.
