Indezine Logo

  This is the print version of this page. All content is copyright Indezine.com 2000-2021.



Edit Chart Data in PowerPoint 2013 for Windows

Learn how to edit chart data in PowerPoint 2013 for Windows. This data is typically stored in an embedded Excel sheet.


Author:

Product/Version: PowerPoint 2013 for Windows

OS: Microsoft Windows 7 and higher



Learn PowerPoint

Learn how to prevent mouse-clicks from advancing slides.



When you insert a new chart in PowerPoint 2013 for Windows, you might notice that an instance of the Excel sheet containing some dummy data for your chart pops up within PowerPoint. You then change data as needed within Excel sheet to auto-update the chart on your slide. However, this Excel instance that stores your data has no separate existence, and there's no separate Excel sheet that contains your data. In fact, this Excel sheet is stored within your PowerPoint presentation itself.

Do I Need Excel to add a Chart in PowerPoint?

To create and edit charts in PowerPoint 2013 for Windows, you must also have Excel 2013 installed.

Well, what do you do if you want to edit the chart data after a week, a month, or even a year after you created that chart? Simple, you just summon the instance of the Excel sheet containing the chart data again and make the required changes.

Follow these steps to learn more in PowerPoint 2013 for Windows:

  1. Select the chart on your slide. For this tutorial, we have used (and selected) a Column chart, as shown in Figure 1, below.
  2.  Chart selected on the slide
    Figure 1: Chart selected on the slide
  3. With the chart still selected, select the Chart Tools Design contextual tab of the Ribbon and click the lower half of the Edit Data button, highlighted in red within Figure 2, below.
  4. Edit Data button
    Figure 2: Edit Data button
  5. Doing so opens the Edit Data drop-down menu containing two options, as shown in Figure 3, below.
  6.  Edit Data drop-down menu
    Figure 3: Edit Data drop-down menu
  7. Edit Data

  8. Selecting this option will open an instance of the Excel sheet containing the chart data within PowerPoint as shown in Figure 4, below.
  9. Instance of the Excel sheet containing the chart data opened within PowerPoint
    Figure 4: Instance of the Excel sheet containing the chart data opened within PowerPoint
  10. You can also achieve the same result by either clicking the upper half of the Edit Data button, highlighted in blue within Figure 2, shown earlier on this page, or by right-clicking the chart and then selecting the Edit Data option within the resultant contextual menu.
  11. Edit Data in Excel 2013

  12. Selecting this option will launch Excel 2013 and open a new Excel sheet containing the chart data, as shown in Figure 5, below.
  13. Excel sheet containing chart data
    Figure 5: Excel sheet containing chart data
  14. Select either the Edit Data or the Edit Data in Excel 2013 option, and within the resultant Excel sheet, you can change the Category and/or Series names and also the values they represent. To do so, select the particular cell in the Excel sheet, and overtype (replace) the new value (or name) as required. Figure 6 shows all values of the sample chart changed except the names (compare Figures 4 and 6).
  15. Chart data changed
    Figure 6: Chart data changed
  16. Tip: Within the smaller Excel window, you can click the icon representing Excel (highlighted in red within Figure 6, above) to launch the complete Excel interface, as shown in Figure 5, earlier on this page.
  17. When you are done editing names and values within the Excel sheet, go ahead and close Excel. The changes made will automatically reflect within the chart on your PowerPoint slide.
  18. Save your presentation.

See Also:

Chart Data: Edit Chart Data (Glossary Page)

Edit Chart Data in PowerPoint 2016 for Windows
Edit Chart Data in PowerPoint 2011 for Mac

You May Also Like: Speaking about Speaking: Toastmasters International – by Kevin Lerner | Entertainment PowerPoint Templates


Popular Posts

Creating Slide Backgrounds in Photoshop for PowerPoint
Learn how to create slide backgrounds for PowerPoint in Photoshop.

Formatting Arrows (Arrowheads) in PowerPoint 2016 for Windows
Learn how to format arrowheads for lines in PowerPoint 2016 for Windows.

Creating Semi-Circles in PowerPoint 2013
Learn how to create a semi-circle in PowerPoint 2013.

Apply Two or More Animations to One Object at the Same Time in PowerPoint
Apply multiple animations to one slide object in PowerPoint, and make all animations play together.



Organic Shapes with Brush Edges

You get 8 shape types plus lines as part of this Organic Shapes collection. Each of these 8 shape types have 10 variants. So you end up with 80 hand-drawn shape options! Again each of these 80 shapes have 12 brush stroke styles! Plus you get the lines and arrows in 12 brush stroke styles too. Combine all variations to end up with more than 3000 possibilities.

Buy and Download for $99+ (83 MB)

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Edit Chart Data in PowerPoint 2013 for Windows.


Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Advertise | Feedback | Site Map | About Us | Contact Us

Link to Us | Privacy | Testimonials

PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

©2000-2021, Geetesh Bajaj. All rights reserved.