Delete cells based on value and update chart area

Hello, I have a list of data that I am making a graph with. However, some of the data contains a zero and I would like to remove these from the list. After removing all of the data with a zero entry, I would like to update the area on my graph. The data has item# starting in F2 then going down, and a quantity starting in G2 going down. I would like the script to go through the column and every time it finds a zero value in the G cell, it deletes that cell as well as the cell in column F right next to it. After deleting the cell it should shift the cells below it upwards.

Also, after the useless data has been taken out, I would like to update my chart area. Currently I have a chart that is over 1000 values wide, yet only about 320 are needed. The data will expand with time and I'd like the chart area to update each time the list is sorted. Thank you very much.


EDIT: I should probably also specify that I'm looking for just the cells in column G and F to be deleted when the value in G is zero, not the entire row.

No, and it erased all of my data. Thankfully I had a backup saved and was able to recover it. Also, I'm not trying to delete the entire row only the values in G and F if G is zero. Here's an example:

[COL F][COL G]
Item1 5
Item2 8
Item3 0
Item4 12
Item5 3
Item6 0
Item7 0
Item8 4

In the example table above, I would want the code to recognize that column G has a zero value and then delete those two cells in G and F. Therefore, the resulting table would look like this:

[COL F][COL G]
Item1 5
Item2 8
Item4 12
Item5 3
Item8 4

Originally Posted by extremis

well..that would be another topic...!! as i said,

add to my reputation and make the post as solved ..glad i helped!

Seems to me that the thread is NOT solved? The OP asked 2 questions, 1 linked to the other, and the 2nd part has not yet been touched?
And to be quite honest, if it were me, you would not get any rep's from me after deleting all of my data.

I have 2 suggestions for you -

1. if there is a chance that your VBA will delete data - without the posibility of UNDO, warn the OP to save their data and to work on a back-up copy.
2. dont be so pushy begging for rep points, they are given as a thank-you, they are not a right for responding to a thread