1. First, open excel. When installing the operating system, the computer will install three major office softwares by default, but generally the default version is 2003. If you want to use the higher version of excel, you must uninstall the lower version first, and then download and install the higher version.
2. Charts exist to reflect data more vividly. If you want to make a chart, you must have data corresponding to the chart. Of course, you can also use the data in existing excel tables to make charts.
With the data, you can make a chart. There are two ways to insert a chart. The first method is to click the Insert menu, and then select the Chart option. The second is to directly click the shortcut of the chart wizard to create a chart, which will be available in the general toolbar. If not, you can click the inverted triangle on the right side of the toolbar, click the Add or Delete button, select Common, and check the Chart Wizard.
4. After opening the Chart Wizard, you can see two tabs, one is standard type and the other is custom type. Regardless of the type, the system integrates various styles of charts by default. Although there are many types to choose from, you need to choose the chart style that suits you best according to your own data. You can clearly see the renderings through the preview.
5. Then the data area and series options. You can define the data area to be charted by the buttons marked with red lines in the figure below. If you use pure data, don't forget to change the series name for easy identification. If the data itself has the name of the series, don't forget to check whether the position of the series in the row or column is correct, which will have a preview of the effect and is very convenient for various modifications.
6. Then there are various chart options, such as title, axis, grid lines and so on. If you are interested, you can try each option yourself. On the right is a preview of the operation after the change, which is convenient for viewing the effect after the change.
7. The last and final step. As long as you select the insertion type, a chart is completed. There are two kinds of insertion, one is as an object of a table, that is, as a part of the current table, and the other is as a new table. You can choose which type of insertion according to your own situation.
Matters needing attention
1. When replacing office, you need to uninstall the original version, and then install the new version of office to avoid the phenomenon that different versions of software conflict and lead to unavailability.
Although there are many types of charts, not every type is suitable for your current data. You need to choose the most suitable chart type according to your own data.