Is it possible to display the numbers on a trend line(just like a normal line graph which displays the value when the mouse is over the line)?
I have a chart which has trendline based on actuals for the first few periods and then using the "forecast" property, I extend the trendline for the next few periods.
I have 2 issues:
1. The graph doesnt show the legend for the Forecast data (if i have actuals for weeks 1,2 and 3 and I forecast for the next 2 weeks, it doesn't show the weeks 4 and 5 on the x axis). - I got around this by using the layered approach, but was wondering if there's some property which could do this.
2. The trendline doesn't show numbers when my mouse is over the line.
