Y
yelaehmit
I have an extensive time-series data base that drives more than 150 (mostly)
column charts. I use a toggle box that lets me to select (using VLOOKUP) any
24-month period of data from the data base to show on each chart.
The system was working well, but has recently stopped working when the data
base was expanded. The toggle box still changes the charting range, but the
charts do not update. If I save and restart the workbook, the charts appear
updated.
I have tried seperating the workbook into multiple workbooks and I have
tried spreading the charts over multiple worksheets, but the problem persists.
I do not receive any memory warnings (the problem is consistent accross
multiple PC's each with up to 0.5 gigs of RAM).
Is there a way to "refresh" the charts? VB solutions are okay!
I'm using Excel 2000 SR-1.
Thanks for any help.
column charts. I use a toggle box that lets me to select (using VLOOKUP) any
24-month period of data from the data base to show on each chart.
The system was working well, but has recently stopped working when the data
base was expanded. The toggle box still changes the charting range, but the
charts do not update. If I save and restart the workbook, the charts appear
updated.
I have tried seperating the workbook into multiple workbooks and I have
tried spreading the charts over multiple worksheets, but the problem persists.
I do not receive any memory warnings (the problem is consistent accross
multiple PC's each with up to 0.5 gigs of RAM).
Is there a way to "refresh" the charts? VB solutions are okay!
I'm using Excel 2000 SR-1.
Thanks for any help.