Excel Chart

I have a form I created in VB and it facilitates data entry into a
spreadsheet. Once I fill out the textboxes and click ok, it inserts a new row
into the spreadhseet with the new info below the second row. So all the other
rows containing previously entered info move down. I need to make a chart
that graphs ONLY the most recently inserted rows content. I tried to turn
off absolute referencing in the Data series tab, but every time a new row is
inserted the graph is not redrawn , because it keeps the formerly entered
info from the cells that were in the first row, but are now in the second row
....

I hope I was clear enough...

Anyone knows how to go about fixing this problem?!

Suggest you try the Excel Charts newsgroup.

cheers, kraves



"Red_Star20" wrote:

I have a form I created in VB and it facilitates data entry into a
spreadsheet. Once I fill out the textboxes and click ok, it inserts a new row
into the spreadhseet with the new info below the second row. So all the other
rows containing previously entered info move down. I need to make a chart
that graphs ONLY the most recently inserted rows content. I tried to turn
off absolute referencing in the Data series tab, but every time a new row is
inserted the graph is not redrawn , because it keeps the formerly entered
info from the cells that were in the first row, but are now in the second row
...

I hope I was clear enough...

Anyone knows how to go about fixing this problem?!