this function provides embedded charts in excel from data already present and saved in excel.
HOW TO USE:
1) download the zip file here.
2) open test1.m and set the address of test1.xlsx accordingly.
3) run test1.m, DONE.
once you get round to what the function is capable of then, it is open to you to modify it the way you want it.
note: this function does not save the excel spreadsheet, but it is rather easy to do that any way.
also you can write and modify the function to what ever extent you want... i have left this here to users, any problems or questions let me know.