1st choose Daily chart then go to upper menu -->File ---> Save as ---> in the pop-up box you need to choose file type (csv, prn, html) for example you try csv type---> After saving in csv type open it in Excel or Open Office programm and analyze it but in case if you won't like how the csv file is looking covert it in classic excel format by applying upper menu of Excel or Open Office ---> File ---> Save as ---> in the pop-up choose xlt type (that's 95-97 excel standart) or xml (excel 2003) ---> Analyze
P.S. By the way, keep remember, MT4 data in most times not accurate