| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding an average line
Hi,
The use of additional series is the way to do it. There are more alternatives explained here. http://www.andypope.info/charts/averageline.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Gaijintendo" wrote in message ... I was adding an average line like this Series 1 Series 2 10 average(series1)=25 20 25 30 25 40 25 and plotting the average line. I then tried plotting a linear trendline, with the 'set intercept' set to the average (25). However the lines were not always perfectly horizontal (I can't understand why). Is there a way to create an average line? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Industry Average Line | Charts and Charting in Excel | |||
| adding a line to show average for a data series on a chart | Charts and Charting in Excel | |||
| average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
| Adding an Average line (from data sheet) to a chart automatically. | Charts and Charting in Excel | |||
| Adding an average line to a bar chart | Excel Discussion (Misc queries) | |||
Hybrid Mode
