Displaying trendline numbers

[jcg31]

I have an excel chart that plots historical performance data monthly- - each month displaying the year to date position. Each year is a separate series whose data is plotted on the chart with each month's values displayed in a table below the x-axis (as provided for with excel charting). The future months of the current year are projected using a trendline. Is there a way to display the monthly values of the trendline in either the table or in the charted area?

Thanks for any help.

Jim

 

[oldbrewer]

if you are displaying a trend line you have data points so turn on show data values

highlight chart then chart, chart options, data labels

 

[shg]

To show in a table,

	H​	I​	J​	K​
1​	Month​	Actual​	Forecast​	​
2​	1​	9,671​
3​	2​	9,213​
4​	3​	9,616​
5​	4​	9,942​
6​	5​	10,329​
7​	6​	9,250​
8​	7​	9,631​
9​	8​	10,349​
10​	9​		10,078​	J10:J13: {=TREND(I2:I9, H2:H9, H10:H13)}
11​	10​		10,151​
12​	11​		10,224​
13​	12​		10,297​

 

[jcg31]

Thanks for the quick replies.

Oldbrewer:
I am using 2010, in which, apparently that functionality isn't available on Trendlines.


shg,
My data is displayed horizontally with the months running from column E- P, Years running rows D2:D5 with the most recent three months of data in E5:G3 (we are three months into our fiscal year). I am having difficulty getting the trend formula to work horizontally. Can you provide an example with the data structured as above?
Thanks,
Jim

 

[oldbrewer]

i make my own trend lines using the y mx and c values so my line is just an ordinary line

 

[shg]

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

1​

Month​

1​

2​

3​

4​

5​

6​

7​

8​

9​

10​

11​

12​

2​

Actual​

9,671​

9,213​

9,616​

9,942​

10,329​

9,250​

9,631​

10,349​

3​

Forecast​

10,078​

10,151​

10,224​

10,297​

J3:M3: {=TREND(B2:I2, B1:I1, J1:M1)}

 

[jcg31]

Many thanks!
Jim

 

[shg]

You're welcome.

BTW, you know that on a chart you can extend the trendline left and/or right?