This will open a window from your spreadsheet. Note: If the workbook you're working with has special startup requirements, such as enabling content, you'll need to also do that within the window. The Chart Tools tab appears only when a chart is selected, and the Design , Layout , and Format tabs under it provide different commands that relate only to the selected chart.
Microsoft Excel opens in a new window and displays the worksheet for the selected chart. In the Excel worksheet, click the cell that contains the title or the data that you want to change, and then enter the new information. If the Edit data button isn't available, read these troubleshooting articles from the Office Answers forum:. PowerPoint chart will not open Excel table when trying to "edit data". To learn how to insert an Excel chart into a presentation, see Use charts and graphs in your presentation.
Change chart data on a slide On the slide, select the chart that you want to change. Tip: To prevent that data from being displayed in the chart, you can hide rows and columns in the table. For example, in a column chart, click a column, and all the columns of that data series become selected.. Tip: To vary the color by data point in a chart that has only one data series, click the series, and then click the Format tab.
Click Fill , and then depending on the chart, select the Vary color by point check box or the Vary color by slice check box. Depending on the chart type, some options may not be available. On the Charts tab, under Data , click Plot series by row or Plot series by column. If Switch Plot is not available. Switch Plot is available only when the chart's Excel data table is open and only for certain chart types.
Under Series , select the data series that you want to remove, and then click Remove. Under Series , click Add , and then in the Excel sheet, select all the data that you want to include in the chart. Tip: To vary the color by data point in a chart that has only one data series, click the series, and then click the Chart Layout tab.
Under Current Selection , click Format Selection. In the navigation pane, click Fill , and then depending on the chart, select the Vary color by point check box or the Vary color by slice check box. Under Labels , click Data Labels , and then in the upper part of the list, click the data label type that you want. Under Labels , click Data Labels , and then in the lower part of the list, click where you want the data label to appear.
Under Labels , click Data Table , and then click the option that you want. In the navigation pane, click Scale , and then under Horizontal axis type , click Date. A purple outline indicates a row or column used for the category axis.
A green outline indicates a row or column that contains data series labels. A blue outline indicates data points plotted in the chart.
Create a chart from start to finish. Get Microsoft chart templates. Table of contents. Create a chart from start to finish Article Add or remove titles in a chart Article Show or hide a chart legend or data table Article Add or remove a secondary axis in a chart in Excel Article Add a trend or moving average line to a chart Article Choose your chart using Quick Analysis Article Update the data in an existing chart Article Use sparklines to show data trends Article.
Next: PivotTables. Table of contents Charts. Which version of Office are you using? Office for Mac Office for Mac If you still want to link the graph from Excel to the slide in PowerPoint, scroll down to see how to do it. I suggest you consider creating the graph in PowerPoint with data copied from Excel. Set up the data required for the graph in a set of Excel cells.
Because the data is in the PowerPoint file, you or others can update it at the last minute if needed. Watch this video to see how easy it is. When using this method, how can you make sure the latest data is used for the graph?
By using a consistent procedure that includes documentation. Follow the same procedure each month for copying the cells from the current version of the Excel file to the data table for the graph on the appropriate slides. Then, update either a text box on the slide or the Slide Notes with the date and time of the update and the file name the data came from. That way, you, or anyone else, will know where the data came from and when it was last updated.
If you are presenting financial information, this page gives practical advice to make an effective visual presentation. If you are part of a team who presents financial or operational information to management and executives, my customized training delivers immediate ROI.
If you have to communicate the results of analysis often, you can learn about many more ways to use Excel tables and graphs in PowerPoint with my ecourse After the Analysis: Communicating results from Excel in PowerPoint.
If you want to link a graph from Excel to the PowerPoint slide, here are two methods to do it. I will describe each method, and then show a table that summarizes the differences. Each method starts with you creating the graph in Excel first, because we will be copying the graph created in Excel into the PowerPoint slide.
So, I have a very simple presentation in PowerPoint just one slide with one chart that was created from Excel table and need to update it with recent data via VBA, no matter from Excel or PowerPoint script should run. It seems to run but made no changes.
Then I began to search in web for solutions and find, for example, the following topic on StackOverflow. For an answer by Optimistic Busy it run without errors and gives me an output in MessageBox, but it changes nothing in PowerPoint chart.
I also tried answers from other questions on StackOverflow, but unfortunately nothing works for me. I will be happy if anyone helps me to find any working solution -- doesn't matter from Excel or PowerPoint should VBA script be run. This examples were provided by users Optimistic Busy and rinusp on the mentioned above StackOverflow topic. This code when run from PowerPoint gives me an error "Run-time error '91': Object variable or With block variable not set".
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 4 years, 5 months ago. Active 4 years, 5 months ago. Viewed 6k times.
0コメント