Can someone help me on how to update charts.
I have a spreadsheet that have multiple worksheets which is updated daily. Each worksheets has its own data and a curve (in the same sheet). I have write a macro to update the data based on the daily source. However, I do not manage to update the curve related to the data.
FYI, I'm using Excel 2007, but saving the file in *.xls format (some of the users not able to open .xlsx format).