Chart creation: Stacked column, require moving average

[JackDanIce]

Hi,

I have a chart with time (weekly data points) across the x-axis and values (whole numbers) on the y-axis.

Currently each time value column has 3 stacked parts (from base of colum to top) showing items aged:

8-30 days
31-90 days and
over 90 days
​

I'd like to add 3 moving averages for each stack but when I right click on the data series, it won't let me add this.

Does anyone know how I can add this?

Thanks,
Jack

 

[Andrew Poulsom]

You can't add a trend line to a stacked chart. You can add a series that contains the same data and plot it unstacked on the secondary y axis. Format the series with no patterns to hide it.

 

[JackDanIce]

Thanks Andrew, will try that