#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trendline Equation bastien86 Excel Worksheet Functions 5 July 8th 06 03:19 AM
Trendline in pivot table girth69 Excel Discussion (Misc queries) 0 May 19th 06 10:03 AM
Trendline Extract Phil Hageman Charts and Charting in Excel 5 July 6th 05 02:27 AM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 01:21 PM


All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"