R
Rob
The following dataset represents a typical bell curve :
x-axis 1 2 3 4 5 6 7 8 9 10 11
y axis 0 0 5 10 15 30 15 10 5 0 0
If I create a polynomial trendline, it goes negative at the start and finish
(which distorts the actual trend). My question is how to avoid it.
The easy solution would be to for the trendline calculation to ignore the
starting and ending zeroes (but the trendline moves left). Another option
might be to shorten the x-axis but I can't do that as the actual graph has
multiple data sets that span all values.
Can anyone think of a workaround.
Tx in advance
Rob
x-axis 1 2 3 4 5 6 7 8 9 10 11
y axis 0 0 5 10 15 30 15 10 5 0 0
If I create a polynomial trendline, it goes negative at the start and finish
(which distorts the actual trend). My question is how to avoid it.
The easy solution would be to for the trendline calculation to ignore the
starting and ending zeroes (but the trendline moves left). Another option
might be to shorten the x-axis but I can't do that as the actual graph has
multiple data sets that span all values.
Can anyone think of a workaround.
Tx in advance
Rob