moving average with stacked bar chart

Rainer

Hi all,

is there a way to add a trend line to a stacked bar chart? In my report I got some values which are displayed as stacked bar chart (grouped by criteria in chart editor). Additionally I want one line in the chart, which is the moving average of the sum of my criteria values. For example here are some values:

Week 2009/15
valueA 20
valueB 10
Week 2009/16
valueA 15
valueB 12

Moving average should be computed from sum of Week 2009/15 and Week 2009/16.

Grouping the values by criteria causes some problems, because my moving average is also grouped.
Any ideas?

Thanks Rainer