Provides friendly Word processing, Spreadsheets & Presentation software.


Create Chart

Release Date: 03-19-12

The following steps show how to create a chart:

1. Select the cells that contain the data you want to plot in a chart. For example, select cell range A2: E6 in the worksheet below.

select the date area

Figure 3.2—3 Select the data area

2. On the Insert Tab, in the Chart group, click Chart. The Chart Type dialog box will pop up.

3. Click the suitable chart type in Chart Types. In the following example we choose Clustered Column from the Column chart

4. Click the Next button, and the Source Data dialog box will pop up. There are two tabs in the dialog box: Data Range and Series. The Data Range tab is used to modify the data range of the chart. The Series tab is used to change the name, value and category (x) axis labels of the data range.

select the chart type

Figure 3.2—4 Select the chart type

set the data area

Figure 3.2—5 Set the data area

5. Click Next, then the Chart Settings dialog box pops up. There are 6 tabs: Titles, Axes, Gridlines, Legend, Data Labels and Data Table in the dialog box. Enter the corresponding titles in the boxes like Chart title, Category (X) axis, Value (Y) axis respectively. Click the other tabs and choose the relative settings according to your needs.(For example, in the "Title" tab in the "Chart Title" text box, enter "2011 sales statistics" and in the "Value (Y) axis" text box, enter the units as "million"。See examples of English screenshots)

6. Click Finish. You can then get the chart you want in the current worksheet. Shown as follows:

chart setting

Figure 3.2—6 Chart Settings


Figure 3.2—7 Chart