Excel creates a basic chart

We learned a lot about the basics and skills in the Excel instance series, including illustrating the basics of Excel, entering Excel data, using Excel formulas and functions, and more. Next, we'll continue to learn a very interesting content, the production of Excel charts, in the form of examples.

Excel charts make it easier to express our views by drawing data graphically, displaying data more visually, making comparisons or trends at a glance.

In this lesson we will create the most basic charts through the Chart Wizard. In order to facilitate the following operation with the reader friend, the article at the end of the original file for everyone to download the reference, friends can download it to the local computer, and then open it and the following steps to operate together.

Example background: Zhang is a sales director, he is responsible for managing three departments, almost to the end of the year, in order to use Excel statistical analysis of sales, he has three departments in the fourth quarter of 2004 sales performance in the Excel worksheet (Figure 1).

In order to make the performance of three departments more intuitive table display, he will be through the Excel "Chart Wizard", the data into a chart.

Thought analysis: Using the Chart Wizard to make a chart, the first step is to select the data area where the chart is generated, and then follow the instructions in the Chart Wizard to quickly generate the basic chart.

Operation Steps:

First, create a chart

1. Open the Create basic chart (original file) workbook file, go to the Practice worksheet, and select the data area "A1:D4" where you want to generate the chart.

2. Click the Chart Wizard button on the Standard toolbar (Figure 2). or select the Insert → chart command for the menu. Opens the Chart Wizard dialog box.

3. The default chart type is column chart and the chart type (Figure 3), and you can see a preview of the resulting chart appearance by clicking the Press and View Sample button below.

4. Clicking the Finish button directly will result in the resulting chart in the current worksheet (Figure 4).

Dynamic updating of data in a chart

After you generate the chart, you find that the department's Shring should be 120, do you need to change the B3 cell to 120, and then regenerate the chart? There is no need to directly change the B3 cell data from 85 to 120 after the return confirmation, you can see the Department Shring data Column chart automatically updated.