Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 8th 17, 03:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 75
Default Adding a Trendline Problem

Hello,

Using Excel 2007 and W 10 on a PC.

Have a very simple graph.
Just Blood p reading vs. date.
Shows up fine.

But no matter what I try or do, I can't get it
to generate a Trendline.

Have selected the curve, and then tried from both the right-click, and
also the pull-down tab for.

Nothing seems to work.

Probably something "major" I am not doing, or something the program just
doesn't "like".

Any thoughts on what I might be missing ?

Thanks,
Bob

  #2   Report Post  
Old February 8th 17, 03:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,538
Default Adding a Trendline Problem

Hi Bob,

Am Wed, 8 Feb 2017 09:10:13 -0500 schrieb Bob:

Using Excel 2007 and W 10 on a PC.

Have a very simple graph.
Just Blood p reading vs. date.
Shows up fine.

But no matter what I try or do, I can't get it
to generate a Trendline.

Have selected the curve, and then tried from both the right-click, and
also the pull-down tab for.

Nothing seems to work.

Probably something "major" I am not doing, or something the program just
doesn't "like".


you have to choose the kind of trendline.
Try:
Right click to the dataserie = Add Trendline and choose "polynominal"
or "Moving Average".
Or select a dataserie =Chart Tools = Design = Add Chart Element =
Trendline and choose one of the trendlines.


Regards
Claus B.
--
Windows10
Office 2016
  #3   Report Post  
Old February 8th 17, 07:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2015
Posts: 10
Default Adding a Trendline Problem

On Wednesday, February 8, 2017 at 9:10:16 AM UTC-5, Bob wrote:
Hello,

Using Excel 2007 and W 10 on a PC.

Have a very simple graph.
Just Blood p reading vs. date.
Shows up fine.

But no matter what I try or do, I can't get it
to generate a Trendline.

Have selected the curve, and then tried from both the right-click, and
also the pull-down tab for.

Nothing seems to work.

Probably something "major" I am not doing, or something the program just
doesn't "like".

Any thoughts on what I might be missing ?

Thanks,
Bob


Trendlines only work with scatter graphs, not line graphs
  #4   Report Post  
Old February 8th 17, 07:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,538
Default Adding a Trendline Problem

Hi,

Am Wed, 8 Feb 2017 10:27:29 -0800 (PST) schrieb BottleMan:

Trendlines only work with scatter graphs, not line graphs


that's wrong. You can add trendlines to all chart types.
But with scatter graphs the trendline formula is the exactest one.


Regards
Claus B.
--
Windows10
Office 2016


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
Need help adding trendline to area chart RBear3 Charts and Charting in Excel 3 January 16th 08 01:40 PM
Newbie query about adding trendline pb1 Charts and Charting in Excel 1 November 16th 06 07:34 AM
Adding Trendline To Just Some of the Bars in Chart Carroll Charts and Charting in Excel 2 February 27th 06 02:25 PM
Where is the "Chart Menu" for adding a trendline to a set of #s? Exceller In America Charts and Charting in Excel 1 August 5th 05 08:49 PM
Adding TrendLine Wilhelmina Maloles Excel Programming 0 August 21st 03 05:27 PM


All times are GMT +1. The time now is 03:37 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017