Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i insert the best fit line into my graft please?

how do i insert the best fit line into my graft please?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default how do i insert the best fit line into my graft please?

Clcik on one of the data data points in the graph and the right click mouse.
Select Add Trend Line.

"pidge" wrote:

how do i insert the best fit line into my graft please?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default how do i insert the best fit line into my graft please?

Hi,

A little more -

in 2003: select the series on your chart and choose Chart, Add Trendline...

in 2007: select the series on your chart and choose Chart Tools, Layout,
Trendline, and pick one of the four or choose More Trendline Options to see
all 6 types.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pidge" wrote:

how do i insert the best fit line into my graft please?

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
Insert New Line Clare Excel Discussion (Misc queries) 4 July 6th 06 03:40 PM
insert a blank in every second line of a row EliseT Excel Discussion (Misc queries) 6 June 5th 06 01:43 PM
Can you make a scatter graft - if so how? Leanne Charts and Charting in Excel 1 August 3rd 05 10:21 PM
Insert a line into all worksheets in one go. Paul Cookson Excel Discussion (Misc queries) 2 June 6th 05 05:04 PM
Insert each line in a new row BrianB Excel Discussion (Misc queries) 0 May 31st 05 03:14 PM


All times are GMT +1. The time now is 07:51 PM.

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

About Us

"It's about Microsoft Excel"