How to quickly generate charts in Excel_one shortcut key and one tool

How to quickly create charts in Excel? Does it require complex operations? PHP editor Apple brings you two methods: shortcut keys and tools, allowing you to generate charts with one click, saying goodbye to tedious steps. Are you still worried about making charts? Read on to make your data visualization easier!

First we select the entire table, and then press CTLR+T to quickly beautify the table, which pave the way for us to make charts.

Then we select all the tables again and press ALT+F1 to generate a histogram.

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

But the 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 separately.

The above is the detailed content of How to quickly generate charts in Excel_one shortcut key and one tool. For more information, please follow other related articles on the PHP Chinese website!