Create a chart

Some of the content in this topic may not be applicable to some languages.

Which Office program are you using?


Word

Charts display data in a graphical format. This can help you and your audience visualize relationships between data. When you create a chart, you can select from many chart types (for example, a stacked column chart or a 3-D exploded pie chart). After you create a chart, you can customize it by applying chart quick layouts or styles.

 Important   You must have Excel installed to create or change a chart. You can order a copy of Excel on the Microsoft Web site.

ShowLearn the elements of a chart

Charts contain several elements, such as a title, axis labels, a legend, and gridlines. You can hide or display these elements, and you can also change their location and formatting.

An Office chart with callouts

Callout 1 Chart title

Callout 2 Plot area

Callout 3 Legend

Callout 4 Axis titles

Callout 5 Axis labels

Callout 6 Tick marks

Callout 7 Gridlines

ShowCreate a chart

You can create a chart in Excel, Word, and PowerPoint. However, the chart data is entered and saved in an Excel sheet. If you insert a chart in Word or PowerPoint, a new sheet is opened in Excel. When you save a Word document or PowerPoint presentation that contains a chart, the chart's underlying Excel data is automatically saved within the Word document or PowerPoint presentation.

  1. On the View menu, click Print Layout.
  2. On the Charts tab, under Insert Chart, click a chart type, and then click the one that you want to add.

Charts tab, Insert Chart group

When you insert a chart into Word or PowerPoint, an Excel sheet opens that contains a table of sample data.

  1. In Excel, replace the sample data with the data that you want to plot in the chart. If you already have your data in another table, you can copy the data from that table and then paste it over the sample data. See the following table for guidelines on how to arrange the data to fit your chart type.
For this chart type Arrange the data
Area, bar, column, doughnut, line, radar, or surface chart

In columns or rows, as in the following examples:

  Series 1 Series 2
Category A 10 12
Category B 11 14
Category C 9 15

or

  Category A Category B
Series 1 10 11
Series 2 12 14
Bubble chart

In columns, putting x values in the first column and corresponding y values and bubble size values in adjacent columns, as in the following examples:

X-Values Y-Value 1 Size 1
0.7 2.7 4
1.8 3.2 5
2.6 0.08 6
Pie chart

In one column or row of data and one column or row of data labels, as in the following examples:

  Sales
1st Qtr 25
2nd Qtr 30
3rd Qtr 45

or

  1st Qtr 2nd Qtr 3rd Qtr
Sales 25 30 45
Stock chart

In columns or rows in the following order, using names or dates as labels, as in the following examples:

  Open High Low Close
1/5/02 44 55 11 25
1/6/02 25 57 12 38

or

  1/5/02 1/6/02
Open 44 25
High 55 57
Low 11 12
Close 25 38
X Y (scatter) chart

In columns, putting x values in the first column and corresponding y values in adjacent columns, as in the following examples:

X-Values Y-Value 1
0.7 2.7
1.8 3.2
2.6 0.08

or

X-Values 0.7 1.8 2.6
Y-Value 1 2.7 3.2 0.08
  1. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data. In the following example, the table is expanded to include additional categories and data series.

Selecting more data for an Office chart

  1. To see the results of your changes, switch to Word.

 Note   When you close the Word document that contains the chart, the chart's Excel data table closes automatically.

ShowChange which chart axis is emphasized

After you create a chart, you might want to change the way that table rows and columns are plotted in the chart.  For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. In the following example, the chart emphasizes sales by instrument.

Chart showing sales by category

However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted.

Chart showing sales by month

  1. On the View menu, click Print Layout.
  2. Click the chart.
  3. On the Charts tab, under Data, click Plot series by row  Plot series by row or Plot series by column  Plot series by column.

Charts tab, Data group

ShowIf Switch Plot is not available

Switch Plot is available only when the chart's Excel data table is open and only for certain chart types.

  1. Click the chart.
  2. On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel.Charts tab, Data group

ShowApply a predefined chart layout

  1. On the View menu, click Print Layout.
  2. Click the chart.
  3. On the Charts tab, under Chart Quick Layouts, click the layout that you want.

Charts tab, Chart Quick Layouts group

To see more layouts, point to a layout, and then click More Down Arrow.

 Tip   To immediately undo a quick layout that you applied, press COMMAND + Z .

ShowApply a predefined chart style

Chart styles are a set of complementary colors and effects that you can apply to your chart. When you select a chart style, your changes affect the whole chart.

  1. On the View menu, click Print Layout.
  2. Click the chart.
  3. On the Charts tab, under Chart Styles, click the style that you want.

Charts tab, Chart Styles group

To see more styles, point to a style, and then click More Down Arrow.

 Tip   To immediately undo a style that you applied, press COMMAND + Z .

ShowAdd a chart title

  1. On the View menu, click Print Layout.
  2. Click the chart, and then click the Chart Layout tab.
  3. Under Labels, click Chart Title, and then click the one that you want.

Chart Layout tab, Labels group

  1. Select the text in the Chart Title box, and then type a chart title.

See also

Edit data in a chart

Change a chart

Chart types

PowerPoint

Charts display data in a graphical format. This can help you and your audience visualize relationships between data. When you create a chart, you can select from many chart types (for example, a stacked column chart or a 3-D exploded pie chart). After you create a chart, you can customize it by applying chart quick layouts or styles.

 Important   You must have Excel installed to create or change a chart. You can order a copy of Excel on the Microsoft Web site.

ShowLearn the elements of a chart

Charts contain several elements, such as a title, axis labels, a legend, and gridlines. You can hide or display these elements, and you can also change their location and formatting.

An Office chart with callouts

Callout 1 Chart title

Callout 2 Plot area

Callout 3 Legend

Callout 4 Axis titles

Callout 5 Axis labels

Callout 6 Tick marks

Callout 7 Gridlines

ShowCreate a chart

You can create a chart in Excel, Word, and PowerPoint. However, the chart data is entered and saved in an Excel sheet. If you insert a chart in Word or PowerPoint, a new sheet is opened in Excel. When you save a Word document or PowerPoint presentation that contains a chart, the chart's underlying Excel data is automatically saved within the Word document or PowerPoint presentation.

  1. On the Charts tab, under Insert Chart, click a chart type, and then click the one that you want to add.

Charts tab, Insert Chart group

When you insert a chart into Word or PowerPoint, an Excel sheet opens that contains a table of sample data.

  1. In Excel, replace the sample data with the data that you want to plot in the chart. If you already have your data in another table, you can copy the data from that table and then paste it over the sample data. See the following table for guidelines on how to arrange the data to fit your chart type.
For this chart type Arrange the data
Area, bar, column, doughnut, line, radar, or surface chart

In columns or rows, as in the following examples:

  Series 1 Series 2
Category A 10 12
Category B 11 14
Category C 9 15

or

  Category A Category B
Series 1 10 11
Series 2 12 14
Bubble chart

In columns, putting x values in the first column and corresponding y values and bubble size values in adjacent columns, as in the following examples:

X-Values Y-Value 1 Size 1
0.7 2.7 4
1.8 3.2 5
2.6 0.08 6
Pie chart

In one column or row of data and one column or row of data labels, as in the following examples:

  Sales
1st Qtr 25
2nd Qtr 30
3rd Qtr 45

or

  1st Qtr 2nd Qtr 3rd Qtr
Sales 25 30 45
Stock chart

In columns or rows in the following order, using names or dates as labels, as in the following examples:

  Open High Low Close
1/5/02 44 55 11 25
1/6/02 25 57 12 38

or

  1/5/02 1/6/02
Open 44 25
High 55 57
Low 11 12
Close 25 38
X Y (scatter) chart

In columns, putting x values in the first column and corresponding y values in adjacent columns, as in the following examples:

X-Values Y-Value 1
0.7 2.7
1.8 3.2
2.6 0.08

or

X-Values 0.7 1.8 2.6
Y-Value 1 2.7 3.2 0.08
  1. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data. In the following example, the table is expanded to include additional categories and data series.

Selecting more data for an Office chart

  1. To see your changes, switch to PowerPoint.

 Note   When you close the PowerPoint presentation that contains the chart, the chart's Excel data table closes automatically.

ShowChange which chart axis is emphasized

After you create a chart, you might want to change the way that table rows and columns are plotted in the chart.  For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. In the following example, the chart emphasizes sales by instrument.

Chart showing sales by category

However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted.

Chart showing sales by month

  1. Click the chart.
  2. On the Charts tab, under Data, click Plot series by row  Plot series by row or Plot series by column  Plot series by column.

Charts tab, Data group

ShowIf Switch Plot is not available

Switch Plot is available only when the chart's Excel data table is open and only for certain chart types.

  1. Click the chart.
  2. On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel.Charts tab, Data group

ShowApply a predefined chart layout

  1. Click the chart.
  2. On the Charts tab, under Chart Quick Layouts, click the layout that you want.

Charts tab, Chart Quick Layouts group

To see more layouts, point to a layout, and then click More Down Arrow.

 Tip   To immediately undo a quick layout that you applied, press COMMAND + Z .

ShowApply a predefined chart style

Chart styles are a set of complementary colors and effects that you can apply to your chart. When you select a chart style, your changes affect the whole chart.

  1. Click the chart.
  2. On the Charts tab, under Chart Styles, click the style that you want.

Charts tab, Chart Styles group

To see more styles, point to a style, and then click More Down Arrow.

 Tip   To immediately undo a style that you applied, press COMMAND + Z .

ShowAdd a chart title

  1. Click the chart, and then click the Chart Layout tab.
  2. Under Labels, click Chart Title, and then click the one that you want.

Chart Layout tab, Labels group

  1. Select the text in the Chart Title box, and then type a chart title.

See also

Edit data in a chart

Change a chart

Chart types

Animate a chart

Excel

Charts display data in a graphical format. This can help you and your audience visualize relationships between data. When you create a chart, you can select from many chart types (for example, a stacked column chart or a 3-D exploded pie chart). After you create a chart, you can customize it by applying chart quick layouts or styles.

 Note   The Excel Workbook Gallery in Excel for Mac 2011 replaces the former Chart Wizard. By default, the Excel Workbook Gallery opens when you open Excel. From the gallery, you can browse templates and create a new workbook based on one of them. If you don't see the Excel Workbook Gallery, on the File menu, click New from Template.

ShowLearn the elements of a chart

Charts contain several elements, such as a title, axis labels, a legend, and gridlines. You can hide or display these elements, and you can also change their location and formatting.

An Office chart with callouts

Callout 1 Chart title

Callout 2 Plot area

Callout 3 Legend

Callout 4 Axis titles

Callout 5 Axis labels

Callout 6 Tick marks

Callout 7 Gridlines

ShowCreate a chart

  1. On a sheet, arrange the data that you want to plot in a chart. See the following table for guidelines on how to arrange the data to fit your chart type.
For this chart type Arrange the data
Area, bar, column, doughnut, line, radar, or surface chart

In columns or rows, as in the following examples:

  Series 1 Series 2
Category A 10 12
Category B 11 14
Category C 9 15

or

  Category A Category B
Series 1 10 11
Series 2 12 14
Bubble chart

In columns, putting x values in the first column and corresponding y values and bubble size values in adjacent columns, as in the following examples:

X-Values Y-Value 1 Size 1
0.7 2.7 4
1.8 3.2 5
2.6 0.08 6
Pie chart

In one column or row of data and one column or row of data labels, as in the following examples:

  Sales
1st Qtr 25
2nd Qtr 30
3rd Qtr 45

or

  1st Qtr 2nd Qtr 3rd Qtr
Sales 25 30 45
Stock chart

In columns or rows in the following order, using names or dates as labels, as in the following examples:

  Open High Low Close
1/5/02 44 55 11 25
1/6/02 25 57 12 38

or

  1/5/02 1/6/02
Open 44 25
High 55 57
Low 11 12
Close 25 38
X Y (scatter) chart

In columns, putting x values in the first column and corresponding y values in adjacent columns, as in the following examples:

X-Values Y-Value 1
0.7 2.7
1.8 3.2
2.6 0.08

or

X-Values 0.7 1.8 2.6
Y-Value 1 2.7 3.2 0.08
  1. Select the rows and columns that you want to appear in the chart.
  2. On the Charts tab, under Insert Chart, click a chart type, and then click the one that you want to add.

Charts tab, Insert Chart group

  1. To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data. In the following example, the table is expanded to include additional categories and data series.

Selecting more data for an Excel chart

 Tip   To prevent that data from being displayed in the chart, you can hide rows and columns in the table.

ShowChange which chart axis is emphasized

After you create a chart, you might want to change the way that table rows and columns are plotted in the chart.  For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. In the following example, the chart emphasizes sales by instrument.

Chart showing sales by category

However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted.

Chart showing sales by month

  1. Click the chart.
  2. On the Charts tab, under Data, click Plot series by row  Plot series by row or Plot series by column  Plot series by column.

Excel Charts tab, Data group

ShowApply a predefined chart layout

  1. Click the chart.
  2. On the Charts tab, under Chart Quick Layouts, click the layout that you want.

Charts tab, Chart Quick Layouts group

To see more layouts, point to a layout, and then click More Down Arrow.

 Tip   To immediately undo a quick layout that you applied, press COMMAND + Z .

ShowApply a predefined chart style

Chart styles are a set of complementary colors and effects that you can apply to your chart. When you select a chart style, your changes affect the whole chart.

  1. Click the chart.
  2. On the Charts tab, under Chart Styles, click the style that you want.

Charts tab, Chart Styles group

To see more styles, point to a style, and then click More Down Arrow.

 Tip   To immediately undo a style that you applied, press COMMAND + Z .

ShowAdd a chart title

  1. Click the chart, and then click the Chart Layout tab.
  2. Under Labels, click Chart Title, and then click the one that you want.

Chart Layout tab, Labels group

  1. Select the text in the Chart Title box, and then type a chart title.

See also

Edit data in a chart

Change a chart

Chart types

 
 
Applies to:
Excel for Mac 2011, PowerPoint for Mac 2011, Word for Mac 2011