Updating charts in excel

Posted by / 02-Mar-2018 13:52

If I were to have data in excel just like the table below, and then make line charts with that data.

All is well and good until I have to come back around and add rounds 11, 12, and 13 to the data.

If you have Power Point slides that report regularly updated financial or numeric data that comes from an Excel spreadsheet, you can save a lot of time by linking the data instead of retyping it.

This technique also allows you to secure the data from others changing it and prevents accidental transposition errors.

This article shows you the step by step procedure for importing linked data from an Excel spreadsheet into a Power Point slide (works in Power Point 2003, 2007, 2010, 2013, 2016).

If you want to learn about the three approaches to using Excel data in Power Point and the different methods for each approach, check out my After the Analysis e-course.

Then select the desired chart type from the menu in Excel’s think-cell toolbar: When you click on this menu item in Excel, the Power Point window is activated.Step 5: Resize and position the table object The table comes on to the Power Point slide looking like a picture type object and can be sized by dragging the corner white circle resizing handles.Drag the corner handles to make the table as large as you want it to be.Step 1: Create the table in Excel The first step is to create the table of data in Excel so that it looks exactly the way you will want it to look on the slide, including titles, row labels, column labels, gridlines, text and background colors and text formatting.Step 2: Copy the table in Excel Using your mouse or arrow keys, highlight the table of data in Excel. The slide layout with a title only is usually a good choice if the imported table will be the main focus of the slide.

updating charts in excel-82updating charts in excel-33updating charts in excel-29

If Power Point is not yet running, it starts automatically.