Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trendline
I have 10 column A data points and 10 column B data points. My graph is
good, but I want to add a horizontal trendline to the data points in the middle of my columns while still showing the other data. help...... -- ang |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trendline
harbal2007 or ang -
One method is to enter some more data on the worksheet for defining the new line. Then use Chart | Source Data | Series | Add ... Another method is to use Add Trendline (but you seem to want a horizontal line, not necessarily a best-fit line). You did not specify what type of chart you have (Line, XY(Scatter), ...), so it is difficult to provide more detailed instructions. - Mike http://www.mikemiddleton.com "" wrote in message ... I have 10 column A data points and 10 column B data points. My graph is good, but I want to add a horizontal trendline to the data points in the middle of my columns while still showing the other data. help...... -- ang |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendline Equation | Excel Worksheet Functions | |||
Trendline in pivot table | Excel Discussion (Misc queries) | |||
Trendline Extract | Charts and Charting in Excel | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel |