Updating last data entered in excel
If you delete the value in D10, then the contents of range G5: G10 will be deleted.
your original code was to run your Macro, put that back into its original form.
To make a dynamic chart, you first have to define some dynamic range names.
You want to create a chart that shows the last twelve months of data.