Hello,

I wish to create a dynamic chart (basic line chart) using excel and VBA.
However , the chart should always display the last 15 lines of column A (date), C (value X) and E (value Y).
Can someone tell me how to do that in VBA ?

Many thanks in advance,

Greg.