Update the data in an existing chart

Change which chart axis is emphasized

You can change the way that table rows and columns are plotted in a chart.  A chart plots the rows of data from the table on the chart's vertical (value) axis and the columns of data on the horizontal (category) axis. You can reverse the way the chart is plotted.

1. Select the chart.

2. Select Chart Design > Switch Row/Column.

Change the order of the data series

You can change the order of a data series in a chart with more than one data series.

1. In the chart, select a data series. For example, in a column chart, click a column, and all the columns of that data series become selected.

2. Select Chart Design > Select Data.

3. In the Select Data Source dialog box, next to Legend entries (Series), use the up and down arrows to move the series up or down in the list.

   Depending on the chart type, some options may not be available.

   Note: For most chart types, changing the order of the data series affects both the legend and the chart itself.

4. Select OK.

Change the fill color of the data series

1. In the chart, select a data series. For example, in a column chart, click a column, and all the columns of that data series become selected.

2. Select Format.

3. Under Chart Element Styles, select Shape Fill   and choose the color.

Add data labels

You can add labels to show the data point values from the Excel sheet in the chart.

1. Select the chart, and then select Chart Design.

2. Select Add Chart Element > Data Labels.

3. Select the location for the data label (for example, select Outside End).

   Depending on the chart type, some options may not be available.

Add a data table

1. Select the chart., and then click the tab.

2. Select Chart Design > Add Chart Element > Data Table.

3. Select the options.

   Depending on the chart type, some options may not be available.