Trend Lines Only?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nev. - 31 Oct 2003 23:43 GMT

If I have data entered in a spreadsheet,
can I have the spread sheet draw trend lines,
but nothing else?

TIA,

Nev.

Reply to this Message

Jerry W. Lewis - 01 Nov 2003 00:54 GMT

Plot the data, add a trendline on the chart, then format the data plot
so that plot symbols have the same color as background (i.e. are invisible).

Jerry

> If I have data entered in a spreadsheet,
> can I have the spread sheet draw trend lines,
[quoted text clipped - 3 lines]
>
> Nev.

Reply to this Message

Marc - 21 Nov 2003 08:11 GMT

Change the colour of your marks and lines into "none". The values will still be there in the graph, only invisible, and you can still make a trendline

----- Nev. skrev: ----

If I have data entered in a spreadsheet
can I have the spread sheet draw trend lines
but nothing else

TIA

Nev

Reply to this Message

Nev. - 28 Nov 2003 16:00 GMT

Thanks to everyone who tried to help me.
The answer was so simple, I just couldn't see the wood for the trees.
There really wasn't a problem in the first place.

First, I would get my Line Graph OK.

Next I would create the Trend Line.
Next I would make the background white.
Then I would make my graph line white (invisible).
The graph line became invisible, and I had the Trend Line, great,
but then all the big black points of the Graph Line became visible.
I became absolutely f.f.fr.fr.frustrated!! Going crazy!!
The black points became a mind block.

I could not see past the black points for ages.
Then one day I took another step,
I just clicked on an empty part of the chart, and voila,
the Graph Line points just went away.
I felt a right, royal twit.

Nev.

> Change the colour of your marks and lines into "none".
> The values will still be there in the graph, only invisible,
> and you can still make a trendline.

Reply to this Message