Displaying trendline numbers

jcg31

Board Regular
Joined
Aug 20, 2006
Messages
176
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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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
 
Last edited:
Upvote 0
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​
 
Upvote 0
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
 
Upvote 0
i make my own trend lines using the y mx and c values so my line is just an ordinary line
 
Upvote 0
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)}
 
Upvote 0
You're welcome.

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

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top