Dynamic Chart Range and Chart Update

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I have a pie chart which feeds off dynamic ranges. The ranges get
populated using a data validation drop down box. Effectively, you pick
a number from 1-8, data is pasted into the dynamic ranges with VBA code
(Case Select) and the chart updates.

Even though the pies update in the chart, the title of the chart which
is fed from a Choose formula on the data sheet ("GenStats") does not
update unless I physically go to that sheet and hit Shift F9. I am not
sure why this is because in my code I say:


Worksheets("GenStats").Select
ActiveSheet.Calculate

Is this code consistent with my need to Shift F9 the "GenStats" sheet?

Thank-you in advance
 
Try

Appl;ication.CalculateFull

This forces a full recalc of all open workbooks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 dynamic chart range correction 11
Dynamic chart problem 1
Mysterious dynamic chart (that suddenly isn't!) issue 1
Dynamic Chart ranges 6
How I can set dynamic pivot table ONLY when I have enough data point 1
2D Dynamic Charts 5
to make column letter dynamic in charts 2
Chart Design Recommendation 1

Back
Top