Need to display weekly giving compared to monthly need

[merrittjr]

I need a chart for our church newsletter that will show our weekly giving compared to our monthly needed income. For example, let's say our budgeted need for June is $12,000. I want to be able to show in a chart how each week's worth of giving is adding up to that $12,000. I want it to be able to show each week's giving and not just the total $ given up to that point. I hope this makes sense. Thanks.

[DBY]

Hello
Maybe a little late and I'm not sure about your data layout but if you're still looking for suggestions, perhaps the attached example might give you a few ideas.


Hope this helps.
DBY

[merrittjr]

That's perfect! Thank you!