Joining up data points

[Emma Hope]

I have six known data points at 0%, 9%, 10%, 11%, 12% and 13%. I want to try
and work out what the result will be for 1%, 2% etc up to 8%.

I have drawn a graph and effectively just want to join 0% to 9% but it won't
do that, i have looked at the formulae like growth, trend, forecast etc but i
can't seem to make them work.

Please can anyone help me and if it is one of these formulae i need, please
can you help me with exactly how to use it, as i haven't managed it with the
MS Help yet.

Thanks


X Axis Y-Axis
0.00% 100%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
7.00%
8.00%
9.00% 88%
10.00% 79%
11.00% 66%
12.00% 41%
13.00% 8%

 

[David Biddulph]

Tools/ Options/ Chart
Plot empty cells as interpolated.

 

[Emma Hope]

David,

Perfect, thank you very much, i hoped it would be this simple but i didn't
expect it would be!

Thanks
Emma