[Excel] How to make a bar chart with a reference marker

Add a marker to a bar chart when each category has its own reference value.

Excel bar chart with a reference marker.

Design notes

• This a simple way of adding an individual reference value for each category instead of a general reference for all categories.

Video

Notes