Graphs not refreshing

I have a series of 6 graphs that reference data from a chart a few rows above. For some reason every time I open my Excel file the graphs all are reverted back to default values.

ie: the data shows # of survey respondents for 6 different surveys and each graphs shows 12% responded, 88% did not respond. Even though the data in the charts above that actually don't even show those rates! I think the 12% and 88% was the test data I originally had in the charts when I created the graphs.

The weird thing is it looks like the graphs do reference the correct cells as if I click on the graph and go to copy and paste it updates the graphc with the correct info. But if I save the excel file, close and re-open it, it's back to 12% and 88% again.

How do I get the graphs to always refresh based on the data above?

PS. I do have a "refresh" button I created and can add some VB script to it to update the graphs if that's what is needed.....but need help figuring that out though!

thanks in advance!
Cam.

Hi there,

Can you post your workbook so that I can have a look at it?

Regards,

Greg M