| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding an average line
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? |
| 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) | |||
Threaded Mode
