I'm trying to share prices across over a five-year period and would like to graph it on a daily basis. but the problem is that when i try to chart five-years worth of daily prices, the grapg loses ts clearity. So, i would like to know that is it possible for me to run a Macro or something else which would automatically convert daily data in to monthly excel sheet? Is it possible for me to do so? Kindly provide me the correct solution for the above issue.
Bookmarks