Donut chart not updating

[sobrien1234]

I have a donut chart that won't update we the figures change. it used to but now it has stopped doing it. I've redone the chart and updated everything twice and it still won;t update when the numbers change. The numbers are based on formulas (i.e. I don't change them manually) - even if I change the figures manually it won't update?

Suggestions?

 

[Sam_D_Ben]

Will this work.

 

[sobrien1234]

Will this work.

Unfortunately they are already my current settings. The formulas update, but the graph doesn't

 

[Moses99]

can you give the file, might play with it .

 

[sobrien1234]

can you give the file, might play with it .

It's massive - however when I closed it down and re-opened it worked again? Could it be related to other workbooks that are open. it's really odd, happened before.

If it persists I will chase you up on your offer.

Much appreciated!!

 

[Moses99]

just delete important data in your file. maybe leave arbitrary numbers

 

[Sam_D_Ben]

Unfortunately they are already my current settings. The formulas update, but the graph doesn't

I guess it’s a kind of trick.
For example if your source data is in Column A and in Column B, like A1:B10. Next converting your source data in to a table. For that select any cell in your source data, then go to Home tab-> Styles-> Format as table. Now its converted in to a table format and see of it works. Thank You.