Powerpoint 2007 chart not updating

The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. If you need to edit the charts then clearly you will either need to edit the underlying Excel files, or be able to edit in PowerPoint As you are using PowerPoint which provides full Excel support unlike PowerPoint which has a datasheet I would Part 1 Link your Excel file data to the Excel data underneath each chart Provide the ability to either use that data directly, or over-ride it with user data This gives you a flexible solution, except that Excel underlying each chart cannot be updated automatically via a PowerPoint menu Update Links command.

Part 2 You can use the code below to test each whether each shape on each slide has a chart. Slides For Each shp In sld. Shapes If shp. ChartData pptChartData. UpdateLink pptWorkbook. Thanks for the prompt reply. I had copy and paste this vba in powerpoint and this vba is able to run. However, I am getting a pop up menu asking to update the file in my documents folder.

My source i. How do i remove the pop up menu. Many thanks for this vba. I make a slight modification to the vba code and now its updates perfectly. This code is a life saver. Thanks again. This is a great answer. I did notice, however, that every time I made a change in the code my dashboard worked.

If you're using the Workbook module I wasn't in this case , just create a new module and reference that instead. I faced the same problem with my work last week when I added some more calculation to my sheet.

After that, using radio buttons to select data to be presented on graphs did not update the graphs anymore. If I understood it right, if there are more than formulas that have another cell as a reference in your file, Excel starts to optimize the calculation and in some cases graphs don't update correctly anymore.

If there is a workaround for this without using VBA macros, I would be glad to hear that can't use those as the files need to be shared through SharePoint without VBA macros. This will cause the chart to update the data selection.

I had the same problem while working through a tutorial very frustrating when you follow the steps and don't get the expected result. The tutorial to create a pie chart wanted me to select range A3:A10 , then also select non-adjacent range E3:E I did so.

I got the chart. It then asked me to change a value and watch the percentage change, then to look at the pie chart and see the update. I looked at the data source for the pie chart, and the range was bizarre. It had the A3:A10 range notated properly, but the E10 cell reference repeated several times, and it had all of the E cells listed in a random order.

It looked like. Problem solved. Sometimes it's a matter of cleaning up your code so the calculations processor has less to sort through. I struggled with this problem, too. Finally solved it by recalculating the sheet that has the chart data AFTER the custom function has recalculated.

So, in Sheet 1, I have a cell that contains. In the VBA module, the function is defined as Volatile, to ensure that ComputeScore runs after any updates to the spreadsheet. This additional round of calculation of the chart data causes the chart to update now, rather than later or not at all.

The setting of EnableEvents and xlManual keeps infinite recalc loops and other event problems from occurring. This might look extremely basic but I just tried Manual Calculating on the spreadsheet where the charts were by pressing F9 and it worked! Tha VBA code for it is simply:. As i tried pretty much ALL the presented solutions and since none worked in my case, I'll add my two cents here as well.

Hopefully it helps someone else. The consensus on this issue seems to be that we need to somehow force excel to redraw the graph since it is not doing it when it should. My solution was to kill the X-Axis data and replace it with nothing, before changing it to what i wanted. Here my code:. My two cents for this problem--I was having a similar issue with a chart on an Access report.

I was dynamically building a querydef, setting that as the rowsource on my report and then trying to loop through each series and set the properties of each series.

What I eventually had to do was to break out the querydef creation and the property setting into separate subs. Additionally, I put a. On changing the values of the source data, chart was not getting updated accordingly. Just closed all instances of excel and restarted, problem disappeared. I had a similar problem - Charts didn't appear to update. I tried just about everything on this thread with no luck. I finally realized that the charts that I was copying and pasting were linked to the source data, and that is why they were all showing the same results.

I just had the same problem, and also found that the line would only display if I put in bad data characters instead of numbers. This caused the line to appear, but changing back to valid data caused it to disappear again. I was having a similar problem today with a file with a large number of formulas and several database connections.

The chart axis that were not updating references ranges with hidden columns, similar to others in this chain, and the labels displayed the month and year "MMM-YY" of the dynamic data. I tried all solutions listed except for the VBA options as I'd prefer to solve without code.

And everything immediately updates when values change. Happy days again!!! From reading the other contributors issues above I started to think that the Charts were having problems with the DATE data type specifically, and therefore converting the values to text with the TEXT function resolved my issue.

Hopefully this may help you as well. Just change the format within the double quotes second argument of the TEXT function to suit your needs. I had the same problem and none of the things you mentioned in question worked for me until I just activated sheet. The accepted answer didn't work for me neither. For me the macro didn't update the x-axis for all series, but only the first one. The solution I found was to update the x-axis for all series and then it refrehsed also I had code to change the format of the x-axis, but I don't think that that was the problem.

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. Chart won't update in Excel Ask Question. Asked 10 years, 11 months ago. Active 2 years, 3 months ago. Viewed k times. RefreshAll DoEvents None of these update or refresh the chart I do notice that if I type over my Data Series, actual numbers instead of calculations, it will update the chart - it's as if Excel doesn't want to recognize changes in the calculations Has anyone experienced this before or know what I might do to fix the problem?

Thank you. ChrisB 2, 5 5 gold badges 27 27 silver badges 53 53 bronze badges. Register To Reply. Re: Chart not updating. Remember you are unique, like everyone else.

Re: Chart not updating Yes, you're right. I really need an example posted to see the behaviour. Cold you post an example with a small dataset of dummy data?