Trendlines: When Excel Will Draw, And When Will Not Be Drawn, ForScatter Charts

B

Bob

Hello,

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

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 4 4
Jan 5 8
etc.

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

If I:

go to:

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

Then, The Trendline 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top