Trendline Question

[Bob]

Hello,

I tried a few weeks ago posting this to the Charting Group, but never
received any replies.
This is really "bugging" me, and would really like to try to understand
what is happening.

If anyone could help me, would really appreciate it.

Have been going around circles with this, trying to understand.
Using Excel 2007 and W7.

If anyone could explain for me the limitations of when a Trendline
(linear) will, or will not, be drawn on a Scatter chart I would be most
appreciative.

My data looks like this:
Col A Col B
Jan 1 5
Jan 2 6
Jan 3
Jan 14 4
Jan 15 8
etc.

Many of the dates have no data in Col. B (as shown for Jan 3, e.g.)

And, the Dates are not contiguous; some are missing, as shown.

If I:

go to:

Select Data
Hidden And Empty Cells
"Show Empty Cells As Gaps" Box Is Checked

Then, The Trendline (Linear) shows Up O.K.

But, if I check the box for: Connect Data Points With Line, the
Trendline then disappears.
And, will not allow being generated if this box remains checked.

Why ?

Recently, I had to install a new HD in my Desktop, as old one conked
out. Also re-installed Excel (2007) from MS disks. I am 99.9% certain
that before the HD and Excel re-installs,it did not act this way.

I remember that I always had lines drawn between all the actual data
points,and
Excel would merely skip dates for which I had no data; trendlines
would still appear and be drawn; no problem.

But, I admit, I might be wrong, although I don't think so. But, at my
age,...!

Again, I'm using Excel 2007, and scatter charts.

Any thoughts on ?

Thanks for help,
Bob

 

[Don Guillett]

Hello,



I tried a few weeks ago posting this to the Charting Group, but never

received any replies.

This is really "bugging" me, and would really like to try to understand

what is happening.



If anyone could help me, would really appreciate it.



Have been going around circles with this, trying to understand.

Using Excel 2007 and W7.



If anyone could explain for me the limitations of when a Trendline

(linear) will, or will not, be drawn on a Scatter chart I would be most

appreciative.



My data looks like this:

Col A Col B

Jan 1 5

Jan 2 6

Jan 3

Jan 14 4

Jan 15 8

etc.



Many of the dates have no data in Col. B (as shown for Jan 3, e.g.)



And, the Dates are not contiguous; some are missing, as shown.



If I:



go to:



Select Data

Hidden And Empty Cells

"Show Empty Cells As Gaps" Box Is Checked



Then, The Trendline (Linear) shows Up O.K.



But, if I check the box for: Connect Data Points With Line, the

Trendline then disappears.

And, will not allow being generated if this box remains checked.



Why ?



Recently, I had to install a new HD in my Desktop, as old one conked

out. Also re-installed Excel (2007) from MS disks. I am 99.9% certain

that before the HD and Excel re-installs,it did not act this way.



I remember that I always had lines drawn between all the actual data

points,and

Excel would merely skip dates for which I had no data; trendlines

would still appear and be drawn; no problem.



But, I admit, I might be wrong, although I don't think so. But, at my

age,...!



Again, I'm using Excel 2007, and scatter charts.



Any thoughts on ?



Thanks for help,

Bob

Without thinking about it too much. Have you installed ALL UPDATES