Still don’t know how to quickly generate charts? Recently, some friends who are new to Excel software have expressed that they are still unclear. For this reason, in the following article, the author will share the operation process of quickly generating charts in Excel. Let’s take a look.

​​​​​​​Take the following table as an example.

​​Select all the tables, and then press CTLR+T to quickly beautify the table. This will pave the way for us to make charts.

​​Select all tables again and press ALT+F1 to generate a histogram.

A histogram is generated, and you can click on the design above to adjust the style of the chart.

But your boss wants you to create a separate chart for each department, what should you do? Don't worry, just select the table and click [Table Design] - [Insert Slicer], check the department list, and it's done directly, so that each department can be viewed individually.

Here are the operating processes of Excel quickly generated the chart for you. Friends in need should hurry up and read this article.