SimonK
New Member
Hello Everyone, I hope there is a simple explanation for this issue:
I am working on a soil water balance model in Excel and I need to manually adjust monthly variables attempting to match real collected data.
When I change a value, the chart was updating but is no longer. The only way I've found to recognise the change in the chart is to change datasets and then change it back again. Then I can see the change. (This is tedious)
Is there any tricks people know to refresh the plot of a chart?
The file is pretty big and I'm not at liberty to share the file but I have uploaded a screen shot of what I'm working on.
I am working on a soil water balance model in Excel and I need to manually adjust monthly variables attempting to match real collected data.
When I change a value, the chart was updating but is no longer. The only way I've found to recognise the change in the chart is to change datasets and then change it back again. Then I can see the change. (This is tedious)
Is there any tricks people know to refresh the plot of a chart?
The file is pretty big and I'm not at liberty to share the file but I have uploaded a screen shot of what I'm working on.
Attachments
Last edited: