Get pie chart to use current month's data

[Jo4x4]

Hi everybody,

I have a sheet with Jan to Dec in column a, and then data in eleven columns c-m

Below this, I have two pie charts, one for the current month, and one for the year to date.

How do I get the current month to update and use the current month's data?

Thanks in advance

Jo
Win 7 & excel 2007

 

[ExcelWusgood]

Got it working! Thanks a lot.