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
Thanks for any help.
Jim