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 -
<tbody>
</tbody>
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>