"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years.
I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.


Large file, the data series in the charts are described by named ranges.
I was hoping one of you guys might take pity and help, espeically if you've heard of this before?
I've created a dashboard which should allow a user to specify a time period (data validation), which updates a data table from which 7 graphs read from.
Almost all the time, when I update the data, the charts refresh to reflect this.
However sometimes (randomly) the charts do not update.
Excel chart data label not updating. I checked that the Excel options show Auto Recalc after the macro has run and it's all as expected This is all a bit odd.
I have so much money in the bank I’m going to give away my number one reporting time saving secret HAHAHAHAH not at all! I’m giving it away because I love you and I want to make your life easier. This is how you link Excel to your other reporting software so that your charts will automatically.
Excel charts not updating automatically. This is a discussion on Excel charts not updating automatically within the Techies Corner forums, part of the Trading Career category; I am using large Excel 2002 spreadsheets - circa 50k rows.