Working on the sheet I would do a quick Ctrl-X, Ctrl-V on a piece of the chart (or the whole thing) to force the chart to update. Based on the work arounds posted I came to the following actions as the simplist way to move forward... When I zoom in or zoom out, I can get the expected results. The refresh may not be necessary - more testing needed. Anyway, let's cut to the solution: I didn't want to visibly change the chart title or some other aspect of it, and anyway I noticed this wasn't updating my charts consistently. Screen Updating = True End Sub So, the sheet named Charts Data, which references the custom function cell of Sheet 1, will do a recalculation AFTER the Compute Score() function has updated the cell of Sheet 1, since Worksheet_Calculate() fires after the Compute Score() recalc. Select 'Forwhatever reason a Select statement was needed . What I eventually had to do was to break out the querydef creation and the property setting into separate subs.
This is the only thing I've found to consistently update a chart. Click on the graph you want update - Select CTRL-X, CTRL-V to cut and paste the graph in place... This a great solution because it updates 1000 graphs at once without looping through them all and changing something individually. So I post the solution here if it interest someone. Screen Updating = True End Sub Sub Repaste Charts() Dim Str Temp As String Dim Int Temp Top As Integer Dim Int Temp Left As Integer Set sht = Active Sheet For Each co In sht. Activate 'Grab current position on worksheet Int Temp Top = Active Chart. Dim chrt As Chart Dim chrt Vis As Xl Sheet Visibility Dim sht As Worksheet Dim b Chart Visible() As Boolean Dim i Count As Long Dim co As Chart Object On Error Resume Next Set chrt = Active Chart If Not chrt Is Nothing Then chrt Vis = chrt. Visible = xl Sheet Hidden End If Set sht = Active Sheet If Not sht Is Nothing Then Re Dim b Chart Visible(1 To sht. Sometimes the first time I triggered the calculation the pies would update, but with subsequent calculations the pies would not. This additional round of calculation of the chart data causes the chart to update now, rather than later or not at all. Additionally, I put a I had a similar problem - Charts didn't appear to update.
The Excel Web Access web part, which is available for the Office 365 E3 and E6 subscriptions, is used to display live Excel charts on a wiki or web part page.
Feel free to drop a comment if you see this not working in a particular version.
At Chandoo.org, I have one goal, "to make you awesome in excel and charting".
This blog is started in 2007 and today has 450 articles and tutorials on using excel, making better charts.
So when you adjusted the cell sizes in the sheet with charts and created indirect references through INDIRECT() formula and used it in the named range, excel fetched the content of the cell (the chart) and replaced your cat’s picture with that.
This powerful little trick can help you make interactive dashboards within little space. Here is a link to the downloadable conditional chart display workbook.