Help with scrolling chart series

[tammack17]

Hi all

I'm wondering if anyone can help? I've been trying to get the charts in my excel to update as you scroll through the scroll bar at the bottom. I can get the income, expenses and cash flow to change, but not the chart! I'm wondering if anyone with a little more experience than me can see where I'm going wrong?? It's completely baffled me!

Cheers, Tam

[Andy Pope]

You need to do something similar for the chart data. Build a set of data using the INDEX function and reference that in the chart

[tammack17]

Oh thank you so much!!!