Chart update on Excel 2008

[barnetda]

I have Excel for Mac 2008

I have a simple spreadsheet and created a chart from some data.

Whenever i change the data the chart doesnt update until i click the chart.

There must be an automatic update button but i cant find it.

Any ideas please.

 

[GGJstudios]

Excel > Preferences:

​

 

[barnetda]

Excel > Preferences:

View attachment 289856​

That sorted it. Thank you so much for such a speedy reply.

much appreciated.