Edit data in 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.

Important

You must have Excel installed to create or change a chart. You can order a copy of Excel on the Microsoft Web siteClick this link to open a browser window..

Do any of the following:

Edit data included in a chart

Change which chart axis is emphasized

Change the order of the data series

Remove or add a data series

Change the fill color of the data series

Add data labels

Add a data table

Display dates on a horizontal axis