Mean Line on Charts

[Tia]

How do I display a custom mean? It use to be on the drop
down menu under charts? Now it is replaced with add
trendline and that is not what I want...

 

[Jon Peltier]

Tia -

Put the mean into the worksheet, then use one of these techniques to add
a line to your chart:

http://www.geocities.com/jonpeltier/Excel/Charts/ComboCharts.html#AddLine

- Jon

 

[S. Daum]

With this product, a mean line is as simple as checking one checkbox:

http://www.chartrunner.com

No need for any extra data in your sheet or any vb coding. It might be a
little more than you need - but it will do what you ask...