• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Refreshing Charts

Michael67

New Member
When I update data for an embedded chart often the chart will not update unless I save and close the file then reopen it. Any ideas to get charts to update? F9 doesn't work.

Thanks.
 
Why is the chart embedded? If using regular XL, it should just be regularly placed, not embedded somewhere.

Otherwise, I'd check Formulas - Calculation Options, and make sure your in Automatic mode. Sometimes this gets turned to Manual, which makes everything get screwy.
 
Yes some formulas but I just added some raw data and does not refresh unless I close and reopen. No UDF.
 
Even stranger...moving to the oddball questions
Are PivotTables involved anywhere?
What type of functions are used in your formulas?
Any macros at all in your file?

If still nothing, can you upload the file?
 
Back
Top