To create a chart in an Excel report sheet: Select Insert from the menu ... you can just paste the new data into the data sheets, and the charts and graphs update automatically.