Do you know how to draw pictures in excel?

For many users of Excel, how to draw charts in tables can be a challenge. Today, PHP editor Apple will introduce to you how to quickly and simply draw charts in Excel to make the data more intuitive and clear. Following the steps in this article, you will easily master the skills of drawing in Excel and improve the effect and expressiveness of data display.

1. First, we open the data we want to make into a table, as shown in the figure below:

2. Then, click on the upper menu bar [ Insert] option, randomly select the chart you want to insert. Here I choose the bar chart, as shown in the red circle in the figure below:

3. Next , after we successfully insert the graph, click the [Layout] button above, and then click [Chart Title], we can see that the title of the chart we want to insert is successfully inserted, as shown in the red circle in the figure below:

4. Click the [Layout] button, select [Data Simulation Table], and then select [Show Simulation Table and Legend Item Flag], as shown in the red circle in the figure below:

5. We can see the simulation diagram, which has also been inserted into the table, as shown in the red circle in the figure below:

6. Finally, we click [Layout] and select [Data Label] to display the data above and modify the legend, etc., as shown in the red circle in the figure below:

Looking at the excel drawing steps above, is it very simple? But just not practicing is a false skill, so you still have to practice it to know whether you have mastered it. Let's practice quickly!

The above is the detailed content of Do you know how to draw pictures in excel?. For more information, please follow other related articles on the PHP Chinese website!