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 -

	Jan	Feb	Mar
Org	20	15	3
Dir	124	244	243
Ref	83	124	63
Em	1	1	1
Total	228	384	310

<tbody>
</tbody>