Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
I have a strange situation with my gauge charts. I have a couple of them linked to some basic data that is dynamically connected to a Data Validation drop-down list. When I make a selection the charts don't automatically update. I then enter a new selection and the previous selection is updated. It's like the charts are one step behind. The charts are linked by INDEX MATCH formulae which I typically use with other charts and have not encountered any problems. There are no volatile functions so am confused as to why this is happening. Any ideas?