Data analysis chart how to do?

Excel2020 version, for example, open Excel software, click on the upper right corner of the file, and then click on the New option to create a new blank form. Built in a blank form to enter the appropriate data, the user can right-click to set the cell format, the need to output data to fill in the form. Users who have already done the data form can directly open the form. Then use shift + left mouse button to select the area where the data analysis chart needs to be made. By clicking on the data in the upper left corner of the first cell, hold down the shift key does not release, then the mouse, the left mouse button click on the lower right corner of the target data, so that the region can be selected.

Then click on the menu bar of the Insert menu, in this menu you can see the chart function, click on the icon function will be able to see the bar chart, line graph, pie charts, bar charts, area charts, scatter charts, stock price charts, radar charts, combination charts and other charts. Users can choose the most suitable chart according to their personal preferences. After clicking on any chart, the corresponding chart will appear in the table. Users can drag and drop to move the chart to the appropriate position. You can also zoom in and out.

Users can refine the chart by using the charts on the right side of the icon, adding titles and data labels to the chart elements, clicking on the brush icon to add color to the elements in the chart, and clicking on the funnel icon to filter the values. If the user wants to highlight a value in the data analysis table, he can double click on the number and edit it. The user can fill the color and line of the number or add an effect to the data to make it stand out. If you are using a pie chart, you can also adjust the angle of the chart in the series function. Or adjust the degree of separation of the pie chart.