I have a report that calculates running totals for 1 to 12 months in the group footer.

I have inserted a chart and just want a single line to map the 12 monthly totals, but it does not work.

If I change the chart to a bar one then I get the 12 columns, but this is not what I want.

Is there a way to do this?

Thanks