Updating graph automatically once the data changes

[keilah]

Hi

Silly question your gurus probably get this one in a second.

I have created a graph using a validation list, each time i select a different client the data series - the table updats to show the data for the new c
Client. However, the graph does not update????

I have been into Tool > Option > Calculation to check that the Automatic button is clicked.....NO luck......

Any ideas on how to fix this.....

[rory]

Which version of Excel and is your chart definitely linked to the right data? It would be good if you can post the workbook, because it should update.