If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Charts not updating
Hi,
I am creating a standard excel spreadsheet to display a lot of data. The process flow is: 1) A large quantity of data is copied into a worksheet into pre-named ranges using VBA. 2) There are additional worksheet tabs with multiple graphs that are setup to graph the named ranges. Once the data is copied into the workbook, the graphs update. 3) Additionally, there is a userform on the graph worksheets that allows users to include and exclude data from charts. I use VBA code to show or hide ranges on the data worksheet and in most cases the graphs are updated. The basic code flow: Application.ScreenUpdating = False Application.Calculation = xlCalculationManual 'Turn calcs back on Range("PCL0").Rows.Hidden = False ‘ or true Application.Calculation = xlCalculationAutomatic 'Turn calcs back on Application.ScreenUpdating = true 4) The code works as expected to a point. All my XY scatter chars update normally, however, today I added a bunch of line charts that are plotted by row in non-contiguous ranges. There are 9 of these line charts with 250 series each and none update. 5) The workbook has over a thousand named ranges and more than fifty charts. What I have done: Checked Tools-options-chart – checked show visible cells only option Checked Tools-options-Iterations =10000 Used VBA to: Application.CalculateFull Used VBA to force a rebuild Exported all modules and re-imported all text files. Any other suggestions? |
Thread Tools | |
Display Modes | |
|
|