That's why you might want to add the same custom number format to the data labels, as follows: You'll probably want to format all of the series, but in this example, only the one series changes.The break-even point isn't explicit, but formatting the data labels adds a second layer of information for those values that fall between the actual break-even point and the first formatted axis value.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.
You may need to right-click on the hyperlink and choose Save Target As from the shortcut menu to download this PDF document.
Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data. When you create a chart or change an existing chart, you can select from a variety of chart types (such as a column chart or a pie chart) and their subtypes (such as a stacked column chart or a pie in 3-D chart). To modify a chart, you can: Instead of manually adding or changing chart elements or formatting the chart, you can quickly apply a predefined chart layout and chart style to your chart.
Chart created from worksheet data Excel supports many types of charts to help you display data in ways that are meaningful to your audience. The data points of the data series that are plotted in the chart. The horizontal (category) and vertical (value) axis along which the data is plotted in the chart. For example, you might want to change the way that axes are displayed, add a chart title, move or hide the legend, or display additional chart elements.
Macs are a bit of a crap shoot, unfortunately (but you can always run Parallels, so I hear, and use Excel for Windows! This post describes (and includes a downloadable file of the example) a technique that I’ve used extensively to make short work of updating recurring reports.
Here are the criteria I was working against when I initially implemented this approach: .