And by the way, these are chart objects, not chart sheets. However, the pie charts do not update-for some reason, other types of charts do. I change a cell value which contains, for example, the date range to base the dashboard on, and the named ranges and UDFs are forced to calculate. On the dashboard, there are some pie charts with data series tied to cells which contain these named ranges (the problem also occurs if the data series target cells contain the UDFs directly, bypassing the named ranges). Basically I'm running a dashboard, and I have a bunch of named ranges that are populated with return values from some UDFs. ReDim bChartVisible(1 To ) As BooleanĭO MACRO STUFF THAT CHANGES DATA If Not sht Is Nothing Then The refresh may not be necessary - more testing needed.
This works for me and also handles similar issues with charts as well as chart objects. ( It only seems to be visible charts that have this problem updating ).
My solution has been to make all charts on the active sheet invisible before the change in data, then make them visible again and call chart refresh for good measure. All worked fine in Excel 2003, but in Excel 2007 the chart seems to lose all connection to its data, although manually changing data values in two column triggered a recalc. I have a macro that changes values that are the data for a chart. Has anyone experienced this before or know what I might do to fix the problem?
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 None of these update or refresh the chart I have recreated the chart several times, and on different computers.Ctrl+Alt+F9 updates everything fine, EXCEPT the chart.I can get the Chart to update by saving/closing, or toggling one of the settings (such as reversing x/y axis and then putting it back), or by re-selecting the Data SeriesĮvery solution I have found online doesn't work When I change other cells in the sheet, the Data Series cells are recalculated, and show new values - but the Chart based on this Data Series refuses to update automatically The calculated values never change directly, but only as a result of other cells in the sheet changing
I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values
0 kommentar(er)
