Update graph with new rows

Hi,
I'm copy and pasting a table from the internet into excel. The table is live so the number of rows increases regularly. The table has 9 columns, but I'm only interested in columns C and E which give a duration and description respectively. Throughout the day there will be duplicate descriptions, but I want to have only one instance of each description with the durations summed. Then I want this to be put into a bar graph. It sounds really quite simple, but the issue I'm having is that I don't know how to keep the graph updated with each additional row that is added to the data. I've tried making the graph data range over a large number of rows but the graph will display all of them as the cells have autofilled functions in them. I have no experience with VBA but I've posted this on the VBA forum as it could be the way to go. Hope I've explained this well, and appreciate any help anyone has to offer.
Thanks

Thank you for the quick responses. As requested, here is an example of what I'm trying to do, using the example of a daily schedule. Say I wanted to add to it throughout the day, but the number of rows that will be present at the end of the day is unknown. The second lot of 2 columns takes each individual event and sums the duration of all its instances. Then the third lot of 2 columns removes the blank rows between the data. So because I don't know how many rows it will have I have the formulae autofilled up to some arbitrary row, in this case row 23. The graph on the left is what I would like it to look like. But the graph on the right is what I'm getting because I want it to be prepared for the 23 rows of data if that happens to be the case on one particular day.

Thank you for the quick response. As requested, here is an example of what I'm trying to do, using the example of a daily schedule. Say I wanted to add to it throughout the day, but the number of rows that will be present at the end of the day is unknown. The second lot of 2 columns takes each individual event and sums the duration of all its instances. Then the third lot of 2 columns removes the blank rows between the data. So because I don't know how many rows it will have I have the formulae autofilled up to some arbitrary row, in this case row 23. The graph on the left is what I would like it to look like. But the graph on the right is what I'm getting because I want it to be prepared for the 23 rows of data if that happens to be the case on one particular day.