dynamic pie chart

[cdmacme]

I have a table with months Jan-Dec in the top row, data in rows 2-5 and totals in 6. I have a pie chart that shows the percentages of the current month in relationship to only that month's total. Each month I must "slide" over the source data to the new month in order to show solely the most current month.

I would love to hear some suggestions as to how this could be automated so that when the current month's data is input the pie will update with the new month. I have many automated components of this report that work great; this is one thing that has me stumped.

Thanks for your help -

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD]Org[/TD]
[TD]20[/TD]
[TD]15[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Dir[/TD]
[TD]124[/TD]
[TD]244[/TD]
[TD]243[/TD]
[/TR]
[TR]
[TD]Ref[/TD]
[TD]83[/TD]
[TD]124[/TD]
[TD]63[/TD]
[/TR]
[TR]
[TD]Em[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]228[/TD]
[TD]384[/TD]
[TD]310[/TD]
[/TR]
</tbody>[/TABLE]