How to make Excel drawing

php Xiaobian Yuzai teaches you how to use Excel to chart, and you can easily complete various chart designs without professional software. From basic bar charts to complex pie charts, clear and intuitive data analysis results can be presented with simple operations. Follow this article to learn and master Excel charting skills to make your data more vivid!

When making Excel charts, the first step is to prepare a data table as the basis for the chart. Only with clear data basis can accurate charts be created. Next, we'll show how to create a simple data table.

#2. After the data table is prepared, we now select the table area and click Insert. Then we can see the style of the chart.

3. There are many different charts we can choose from, including line charts, column charts, and three-dimensional charts. You can choose according to your own needs. We choose a two-dimensional histogram here because our tabular data is very simple, and using a histogram makes it easier to compare data.

#4. At this time, the year and sales are displayed together as a histogram, then we need to make some modifications, click the funnel style button on the right side of the icon, and then cancel the year check , so that only the columnar comparison of sales is displayed.

5. If you want to display the year, double-click the position you want to change, and then display it after selecting it. Right-click to find the selection data, then open the dialog box and click Use the red box to select the editing location, and then use the mouse to select the year in the table.

#6. We can also make various adjustments to the icon as needed, including editing charts, displaying details, fonts, background colors, etc. These can be found in the tool buttons shown below.

#7. We can simply adjust the form of the chart to form the chart style in the figure below.

Excel charting is a very basic Excel office software operating skill. Through charting, our data can be displayed more intuitively. If you don't know how to operate it yet, practice it quickly. !

The above is the detailed content of How to make Excel drawing. For more information, please follow other related articles on the PHP Chinese website!