Hi,

I have a chart which looks for data from a table which is dynamic.
Earlier, I was using it perfectly but recently I used
Application.calculation=XLManual in one of the macros of the sheet and
even though I turn it back to automatic, something is messed up. The
tools, options, calculation shows manual and the chart just doesnt
update - no matter what happens in the table. When I try to change
chart type, then only it takes the new data...

Can someone tell me some codes which i can insert in my macro when I
look up for chart so that it gives the latest chart

Thanks,
Anshuman