Skip to main content
ICT Skills 3

Do you know how to edit data in a chart? (20/22)

Yes

Find out

Depending on how a chart was created, there are different ways of editing datapresent in them. For example, if a chart was created in Microsoft PowerPoint with Microsoft Graph, you have to:

  1. Open the presentation in PowerPoint.

  2. Double-click on the chart containing the data you want to edit.

  3. Go to the datasheet (the table providing the information for the chart that can be displayed by clicking View Datasheet ).

  4. Click a cell and make the modifications to the text or numbers of your choice. 

  5. Finally, click outside the chart or datasheet to go back to the slide. The changes in the data will be automatically reflected in the chart.

If charts were created with Microsoft Excel:

  1. double-click the chart you want to edit. 

  2. The Excel menus and toolbars will automatically appear. 

  3. Click the tab of the Excel worksheet you want to edit and edit the data in the worksheet itself. 

  4. Go to the sheet that contains the chart to make sure the chart has been modified and return to the slide by clicking outside the chart. 

Note: In order to modify charts created in Microsoft PowerPoint with Microsoft Graph or Microsoft Excel the relevant software must first be installed.

Why is this information important for translators and translation teachers?
Contents of charts presented in PowerPoint slide shows also have to be translated. Very often, translation tools do not extract text contained in such charts, so this text has to be accessed and translated manually by the translator.

Next