Trendline: how to display forecasted numbers on chart?

[shalin]

Hi Everyone

I have a chart with trend line. The chart is based on two
columns: month and sales. I have sales from Jan to June
and am using trend line to forecast sales for July to
Dec. So far so good.

I would really like to see the forecasted numbers on the
trend line and not just the trend line itself. Is there a
way to display the forecasted numbers for each forecasted
period?

Much appreciate any comments,


shalin

 

[Jon Peltier]

Shalin -

You can't label the trendline (not directly), but you can draw your own
trendline, by computing the monthly values in the worksheet. Add these
values to the chart as a new series, then apply data labels to this
series, with the Show Values option selected.

- Jon