Hi Brian,

Not too clear on how you are building the chart.

I assume you have a stacked column chart with two series.

You are adding a horizontal line programmatically?
Too much work.

Let's say the average value you wish to show is 40.
You can add the value 40 in two cells and add this as
a series to the chart, then right-click on the series you
have just added and change the chart type to line. This
gives you a horizontal line at the value 40.

To show a value label next to the horizontal line, add
another line series, this time with the values [blank], 40.
Then format this last series to show value data labels,
and no marker.

Ed Ferrero