Adapt Chart Record For Free

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. Select Chart Design > Select Data. 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.

To resize a chart, do one of the following: To change the size manually, click the chart, and then drag the sizing handles to the size that you want. To use specific height and width measurements, on the Format tab, in the Size group, enter the size in the Height and Width box. .

Edit or rearrange a series Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK. Changes you make may break links to the source data on the worksheet.

Edit or rearrange a series Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK. Changes you make may break links to the source data on the worksheet.

A line graph reveals trends or progress over time and you can use it to show many different categories of data. You should use it when you chart a continuous data set.

The waterfall chart is excellent for variance analysis and explaining how an ?actual? result was different than a ?budget? or how something has changed relative to an original data point.

Simply format your source data as a table, then create a chart based on that table. When you add more data below the table, it will automatically be included in both the table and the chart, keeping everything consistent and up to date. Watch the video below to learn how to use tables to keep charts up to date.

Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK.