PDA

View Full Version : Updating graph automatically once the data changes



keilah
09-17-2007, 04:38 AM
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
09-17-2007, 05:34 AM
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.