How to Generate Reports from Excel Data (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

We store important information in our Excel worksheet. We also perform necessary operations on our data to analyze different things from time to time. Now, generating a report on a regular time from these Excel data is essential for a company or other institutions. They can understand the improvements or can get proper knowledge on the area that needs to be improved through these reports. In this article, weâ€™ll show you the effective yet simple methods to Generate Reports from Excel Data.

To illustrate, weâ€™ll use a sample dataset as an example. For instance, the below dataset represents 3 Months (January â€“ March), 2 Products (AC and Heater), and the Net Sales of a company. In this article, weâ€™ll generate reports on the Sum of Net Sales by Month and also by Products.

1. Inserting Chart to Generate Reports from Excel Data

Weâ€™ll make use of the Excel Chart feature in our first method. So, follow the steps given below to generate reports from Excel data.

STEPS:

• First, select the range B4:C10.
• Then, go to Insert âž¤ Recommended Charts.

• As a result, the Insert Chart dialog box will pop out.
• There, select your desired chart type from the left pane.
• For this example, select Clustered Column. Itâ€™ll return a chart showing the Net Sales of each product in each month in 2 Different Colors. Hence, itâ€™s easy to distinguish.

• After that, press OK.
• Consequently, youâ€™ll get your desired chart in a new worksheet as shown below.
• Moreover, you can click the Month and Product drop-down icons to sort out your required fields.

• Additionally, you can save the chart as a separate picture if you wish.
• For that purpose, select the chart and right-click on the mouse.
• Lastly, choose Save as Picture.

1.2 Creating Chart Manually

However, if you wish to create your chart instead of the Excel recommendations, follow the below steps.

STEPS:

• Firstly, choose B4:C10 and select the InsertÂ tab.
• Next, choose your desired chart. In this example, press the 2-D Line graph with Markers.

• Thus, youâ€™ll get a line graph as demonstrated below.
• Here, you can modify your chart by pressing the 3 different icons shown in the red-colored box beside the chart.

• For instance, we change the chart style by clicking the middle icon and choosing the desired style. See the figure below.

Read More: How to Make Sales Report in Excel

2. Generating Reports Through Excel PivotTable Feature

PivotTable is a very useful feature in Excel. In this method, weâ€™ll apply this feature to generate our reports. Therefore, learn the following steps for performing the task.

STEPS:

• Select B4:C10 at first.
• Now, click the Insert tab and choose PivotTable âž¤ From Table/Range.

• Next, a dialog box will appear. There, press OK.

• As a result, a new worksheet will emerge. On the right side pane, youâ€™ll get to see PivotTable Fields.
• Subsequently, check the Month and Net Sales.
• Place Month in Rows and Net Sales in the ValuesÂ section.

• Hence, itâ€™ll return the report as shown below where the Sum of Net Sales is on the basis of Months.

• Again, clear the checkmark for the Month and place the Product in the RowsÂ section.

• At last, itâ€™ll return the report based on the products.

• Now, to add Slicer, go to PivotTable Analyze.
• Press Insert Slicer from the FilterÂ section.

• Finally, youâ€™ll get the slicers and make the required changes through the slicers to see your desired results.

Read More: Create a Report in Excel as a Table

How to Print Reports Generated from Excel Data

In the end, we may also need to print the reports instead of just keeping them in the Excel workbook. Hence, learn the process to carry out the operation.

STEPS:

• First of all, go to the InsertÂ tab.
• Press Header & Footer from the Text drop-down.

• Then, type the Header as given below.

• Afterward, hide the sheets that you donâ€™t want on the report.
• For that, select the sheet and right-click on the mouse.
• Choose Hide.

• Next, go to the FileÂ tab.
• In the File window, select Print.
• Choose Print Entire Workbook, Landscape Orientation, Fit All Columns on One Page.

• In the end, select Print and itâ€™ll generate a PDF file of the report.

Read More: How to Create a Summary Report in Excel

Conclusion

Henceforth, you will be able to generate reports from Excel data following the above-described methods. Keep using them, and let us know if you have more ways to do the task. Donâ€™t forget to drop comments, suggestions, or queries if you have any in the comment section below.

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aung Shine

My name is Aung. I have my B.Sc. degree in EEE. From now on, I will be working with Microsoft Excel and other useful software, and Iâ€™ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF