stop excel from automatically updating chart

AutoUpdate is one of the best features in charts and getting rid of that is not that easy. The best way would be using a different datarange for the charts and have a macro to update the dataranges when needed. You might be able to get away without having to use macros if the update means that the old values stay the same and new values are entered at the end of the existing data. If that is the case you could use named ranges or formulas but like said, this approach requires the old values to stay the same.

Another way would be saving the charts as images on your workbook but that approach doesn't allow you to update the charts anymore.

Thanks for the reply.
If you could please clarify a bit about the "different datarange for the charts and have a macro to update the dataranges when needed"

And also by name ranges i assume that u mean, using the offset function with height and width values.

I agree with you for the images solution.

With "different datarange" I mean you have the actual data in one place and copy the bits that you want to use in your charts in another place. The macros copying the data to another location bit comes handy if the original data changes all the time.