excel 2007 add average line to column chart

Add a Horizontal Line to a Column or Line Chart: Series Method.

Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007.
I have a custom line and column chart produced in Excel 2003 but when opened in Excel 2007 the line chart has disappeared, does Excel.
However, what I want to add is a line going across the column series. There doesn't seem to be a way to add user-defined charts in Excel. Now, double-click this line (or in 2007 right-click then select Format Data Series.
Working w/ excel 2007. within a column chart, I would like to add a straight horzontal line to indicate average, rather than a column for the.
Evidently, it was fairly well known how to create an "average line" w/ a column/ bar chart in earlier versions of Excel. However, it seems that.

Evidently, it was fairly well known how to create an "average line" w/ a column/ bar chart in earlier versions of Excel. However, it seems that.

For example, you can combine a column chart with a line chart for an instant visual effect that might make the. The following procedure will help you create a combination chart with results that are similar to those. Tip For our combination chart, we selected the data series for Average Price. .. Excel 2007, Outlook 2007.

AJP Excel Information - Add datum line to chart.
how to add an average line to a column chart? - MrExcel.com.
In Excel 2000-2003 (Charts)(Custom Types)you were able to quickly pick Line - Column. Does anyone know where this option might be in.
Dec 4, 2012. Adding a new line to a line/column chart in excel 2007. averages results as a column for regionsalong with a line for a national average.

excel 2007 add average line to column chart

Thread: Stacked Bar Graph with Average Line - Excel Help Forum.

Adding average lines to column plot - MrExcel.com.
Adding an Average Line to a Chart Using Defined Names | Excel Blog.