Chart refuses to automatically update - help please!!!

Dave_t

New Member
Joined
Jul 14, 2011
Messages
2
I have a chart in a spreadsheet which correlates to data in the same workbook. As the input data changes the graphical output (the chart) updates itself.

My problem comes when I simply increase the size of the spreadsheet. My spreadsheet now is utilizing around 60k rows, instead of around 10k, and now the chart refuses to automatically update it. To 'refresh' the chart I have to re-select the chart data for each series. This is cumbersome, but I have attached this to macros activated by a command button to make it easier and quicker.

Although not great (the chart should update automatically), this could be a working solution for me, however the macro to re-select the series 2 data is not working for some reason. The coding is as follows:

ActiveChart.SeriesCollection(2).XValues = "=GUI!R59C11"
ActiveChart.SeriesCollection(2).Values = "=GUI!R60C11"

My data for series 2 is a single point with x and y co-ordinates at K59 and K60 in worksheet 'GUI'. The error message says it cannot obtain the x value co-ordinate and the whole first line shows yellow in the VBA editor. This is exactly the same code as used for series 1, 3 and 4 of my chart (except for different cell references, obviously), so why won't this work???


Also - I am using excel 2003 but have tried EXACTLY the same workbook on excel 2007 and 2010 and not only does the chart update automatically with in excess of 60k rows, but when I run the macro, there is no error!!! How can this be and what are the problems Excel 2003 seems to be having?!?!?!?

MANY thanks in advance!!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,224,505
Messages
6,179,147
Members
452,891
Latest member
JUSTOUTOFMYREACH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top