Pivot Chart Filtering Problems

[Tom Johnson]

Hi all,

I've inserted a pivot pie chart, which works great when filtering to show each column's (months) data in turn. However when I tick to include all columns in the Pivot Chart filter pane, it only shows the first column's (January) data. The title of the chart displays as January, too, even though all other months are ticked. I would like the chart to show percentages for the whole data set - i.e. the average % for the year.

Does anyone know how to do this? Sorry if my explanation isn't very clear!

Thanks,

Tom