Chart needs to grow with new data automatically

I am trying to figure out a way to show this data in a line type of chart. The data will increase as the project moves forward and so the chart will have to update it's self as new data is added. The data will be in this format and will stay the same just increase in quantity. In the example of data below, there are 4 lines of the data in each set.

This is the data and when new data is added it will be in this format and the same # of lines. The data starts on line 13 and when new data is inserted it goes into line 13 and pushes all of the other data downward. Colum A and B contain the data. I have looked into the dynamic charts but still am clueless.


Date 8/9/07
M.H Complete 53%
# AR's 16
PDRD Complete 51%

Date 8/3/07
M.H Complete 41%
# AR's 28
PDRD Complete 38%

Hi there,

Try the attached. Enter five rows of new data on sheet "Sheet1". Then move to the "Graph Data" sheet & click the "Update Ranges & Graph" button.

Note: As per your example, I've entered a separating row between each set of data - i.e. four data rows plus one separating row.

Please let me know how you get on.

Best regards,

Greg M

Greg,

Thank you very much this is great work you have done. I am using it and it is working great. Thanks again

Hi again Mark,

Many thanks for the feedback. You're welcome - delighted to have helped.

All the best,

Greg M