How to Make Charts and Tables for an Excel Report
Creating reports usually means collecting information and presenting it all in a single sheet that serves as the report sheet for all the information. These report sheets should be formatted in a way that's easy to print as well.
One of the most common tools people use in Excel to create reports is the chart and table tools. To create a chart in an Excel report sheet:
- Select Insert from the menu, and in the charts group, select the type of chart you want to add to the report sheet.
- In the Chart Design menu, in the Data group, select Select Data.
- Select the sheet with the data and select all cells containing the data you want to chart (include headers).
- The chart will update in your report sheet with the data. The headers will be used to populate the labels in the two axis.
- Repeat the above steps to create new charts and graphs that appropriately represent the data you want to show in your report. When you need to create a new report, you can just paste the new data into the data sheets, and the charts and graphs update automatically.
