Dynamic Chart

[spadeintl]

Hello I'm new to the board....

I am learning VB.... I have just inherited some charts.. which requires update fortnightly....

I have to copy A2:I2 with all the formulas, paste and shift down(done using macros).

The chart will then be updated using A1:D28....
everytime the you add a new line the data on line 28 should move out of the chart range..... This is where I'm having the problem..

Not quite sure how to write the VB...Any help pls!

 

[Derek Brown]

Hello and welcome to The Board.
Have a look at the 'Dynamic Chart' section at Jon's excellent site - you may find your answer here:
http://peltiertech.com/Excel/Charts/ChartIndex.html