Modify Chart Form For Free

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.

Editing Data Label Text Select the data label you want to change. For information on selecting data labels, see Selecting Chart Elements. Double-click the selected data label. The Format Data Labels dialog will appear. Choose the Options tab, shown below. Click Apply to see your changes or OK to accept your changes.

To apply the custom template to an existing chart, click on the chart, and then click Chart Design tab on the ribbon > click Change Chart Type > click Templates, and then select the custom template.

Select the chart and go to the Chart Tools tabs (Design and Format) on the Excel ribbon. Right-click the chart element you would like to customize, and choose the corresponding item from the context menu. Use the chart customization buttons that appear in the top right corner of your Excel graph when you click on it.

You can change the style of an existing chart for a different look. For most 2-D charts, you can change the chart type of the whole chart to give the chart a different look, or you can select a different chart type for any single data series, which turns the chart into a combination chart.

Select the chart. Select Chart Design > Edit Data in Excel. Excel opens and displays the data table for the chart.

Right-click the chart, and then choose Select Data. The Select Data Source dialog box appears on the worksheet that contains the source data for the chart. Leaving the dialog box open, click in the worksheet, and then click and drag to select all the data you want to use for the chart, including the new data series.