You can create a chart in Excel, Word, and PowerPoint. However, the chart data is entered and saved in an Excel worksheet. 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.When you insert a chart into Word or PowerPoint, an Excel sheet opens that contains a table of sample data.
3. 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

4. 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.
5. To see the results of your changes, switch back to Word or PowerPoint.

   Note: When you close the Word document or the PowerPoint presentation that contains the chart, the chart’s Excel data table closes automatically.

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.

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

1. On the View menu, click Print Layout.
2. Click the chart.
3. On the Charts tab, under Data, click Plot series by row    or Plot series by column    .If Switch Plot is not availableSwitch 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. 

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.To see more layouts, point to a layout, and then click  .To immediately undo a quick layout that you applied, press  + Z .

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.To see more styles, point to a style, and then click  .To immediately undo a style that you applied, press  + Z .

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.

   

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