Why chart not show trendline as expected

May 15, 2016 at 00:41:17
Specs: Windows XP

Using Excel 2002. I have a table with the following data:

First row: columns numbered from 0 to 29
Second row: data at column 0=10.5, at column 1=11.2, at column 14=11.3, at column 29=11.35

When I create the chart, it does not show a full log trendline that picks up the value in column 0.

It also shows a straight line between column 1 and column 2.Cant figure why, please help!

Thank you.

See More: Why chart not show trendline as expected

Report •

May 15, 2016 at 17:29:56
This post should be here:


message edited by Ewen

Report •

May 15, 2016 at 21:57:20

not sure if you provided the right link, but I just spent more than an hour reading and the answer is not there. I did a few searches and still not there...


Report •

May 16, 2016 at 03:59:48
Ewen's link was not intended to provide a direct answer to your question, it was merely to let you know the proper forum for your question.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

May 16, 2016 at 17:12:39
The answer of course is for you to use that forum to ask your question. There are many users there who are familiar with office programmes who are more than willing to answer your question.

Report •

May 18, 2016 at 07:26:37

Looks like the moderators shifted this post to the Office forum so hopefully some appropriate helpers will respond soon.

Always pop back and let us know the outcome - thanks

Report •

Ask Question