|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart
I posted the following to a general MS Excel Group but did not receive
any replies. Then, I found out that that there is a specific Charting
Group for Excel users, so will transfer the message here.
If anyone could help me, would really appreciate it.
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
My data looks like this:
Col A Col B
Jan 1 5
Jan 2 6
Jan 4 4
Jan 5 8
Many of the dates have no data in Col. B (as shown for Jan 3, e.g.)
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.
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
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
Again, I'm using Excel 2007, and scatter charts.
Any thoughts on ?
Thanks for help,
|Thread||Thread Starter||Forum||Replies||Last Post|
|Excel Chart Trendlines and percentages of increase or decrease||no trend wizard||Charts and Charting in Excel||6||September 14th 09 11:25 PM|
|What's equation for R-Squared value given for chart trendlines?||Sarah||Charts and Charting in Excel||4||October 29th 07 12:39 PM|
|Enter multple trendlines on the same chart.||kirbyre||Charts and Charting in Excel||2||March 1st 06 12:35 AM|
|two scatter plots with two trendlines on one chart||Leo Bueno||Charts and Charting in Excel||1||November 14th 05 12:47 AM|
|Is it possible to change visibility of Trendlines on a Scatter Gra||Engin H.||Charts and Charting in Excel||3||June 25th 05 04:02 PM|