Quick way to create charts in excel

php editor Baicao provides you with the most practical shortcut method for making charts in Excel. In work and study, charts are a way to visually display data, and Excel provides rich chart production functions. Using Excel to create charts can make the data clearer and easier to understand, and you can quickly update the data and customize styles. Next, we will introduce some quick and easy methods to help you easily create beautiful charts in Excel.

1. The picture shows the table data area.

2. First, select the data area, and then press the shortcut key F11 to generate a column chart in another worksheet, as shown in the figure:

3. Copy the column chart generated above and paste it below the data area, as shown in the figure:

4. Adjust the column chart appropriately The size is as shown in the figure:

5. Select the plus sign in the upper right corner of the column chart, and in the drop-down menu that appears, check or uncheck some of the content appropriately. Make the column chart more beautiful, as shown in the figure:

The above is the detailed content of Quick way to create charts in excel. For more information, please follow other related articles on the PHP Chinese website!