You will be my lifesaver if you know how to make an automatic updated chart with macro. My problem is that I have date listed in my worksheet already and the data for each date will be enter daily. If I simply use "shift+end+arrow" to highlight the whole table, then the chart will look odd because of missing data. My guessing is that I still need to use the macro to make the chart and then modify the code. But how????
Thanks a lot