Change the data in an existing chart (2024)

FAQs

How do I change data in an existing 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.

I check Data Table and it is added to the chart. To change the data series for the chart, right-click the chart, click Select Data in the right-click menu, select the Chart data range and click OK.

On the slide, select the chart that you want to change. When you do so, two contextual tabs appear on the ribbon: Chart Design and Format. If you do not see the Chart Design and Format tabs, make sure that you click the chart to select it. On Chart Design tab, in the Data group, select Edit Data.

Right-click the item you want to change and input the data--or type a new heading--and press Enter to display it in the chart. To hide a category in the chart, right-click the chart and choose Select Data.

On the Design tab, in the Type group, click Change Chart Type. In the Change Chart Type dialog box, click a chart type that you want to use.

You can also right-click on the chart and choose 'Edit Data' if you want to amend the graph's data.In the top right-hand corner, you can find several buttons that enable you to edit different aspects of the graph. These include: Chart Elements: this lets you edit data labels and the titles of each axis.

Double-click the table cell. As an alternative, you can right-click the table cell and click Edit Value. Change the contents of the cell and press Enter.

Regarding your query, currently, the feature "Edit Data" in a chart is only available for PowerPoint desktop apps, and not available for the PowerPoint web app. So, you will need to use the PowerPoint desktop app to open and edit the presentation.

Right-click inside the text box and then click the formatting options that you want. You can also use the formatting buttons on the Ribbon (Home tab, Font group). To format the whole title, you can right-click it, click Format Chart Title, and then select the formatting options that you want.

How do you change the chart type of data series in PowerPoint click? ›

Tip: You can also right-click the chart area or plot area, click Change Chart Type, and then continue with step 3. To change the chart type of a data series, click that data series. Note: You can change the chart type of only one data series at a time.

In Word and PowerPoint: Select your chart and then on the Chart Design tab, click Edit Data in Excel. In Excel, select the category title and then in the Home tab, click Sort & Filter > Filter. Next, click the drop-down arrow to select the data you want to show, and deselect the data you don't want to show.

Double-tap the chart you want to edit. Tap Edit chart. Choose from: Type: Change the chart type.

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.

On the Layout tab, in the Labels group, click Data Labels, and then click the option that you want. For additional data label options, click More Data Label Options, click Label Options if it's not selected, and then select the options that you want.