Revise Chart License For Free

Or, click the chart to open Chart Tools > Design, and choose from many chart styles, types, and elements. To edit the data, right-click the chart and click Edit Data to reopen the spreadsheet. Changes in the spreadsheet show up automatically in the chart. Or, under Design, click Data > Edit Data.

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.

From the Chart Tools Format ribbon, you can select an element on the chart (for example, a series), then choose the Format Selection icon in the Current Selection group. With the Formatting Task pane, you can change the shape, style and color.

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

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.

Add or edit a chart title Click anywhere in the chart to show the Chart tab on the ribbon. Click Format to open the chart formatting options. In the Chart pane, expand the Chart Title section. Add or edit the Chart Title to meet your needs. Use the switch to hide the title if you don't want your chart to show a title.

Or, click the chart to open Chart Tools > Design, and choose from many chart styles, types, and elements. To edit the data, right-click the chart and click Edit Data to reopen the spreadsheet.