I have some problems with chart updating in excel. I have two
identical charts in two different sheets(in a large workbook with
about 40 sheets). Those charts get their data from the same sheet. One
from the column F and the other from column G. The problem is that I
have done some additional programming and now one of the charts in not
updating. The right range is there, the data is there, but there is
nothing in the chart! Same story with the other chart except that here
everything goes fine. If I hit Shift+F9 to recalculate nothing
happens. I have also tried application.volitile in the code,
ctrl+shift+F9, but it all just won't help! I have googled a bit and it
seems that Excel sometimes has "recalculation" problems but I haven't
found any solutions for this. Any suggestions?