This is my 2nd post. And I am hoping for positive reply to this one as well.
I have a Line Graph with 2 lines on it. Is it possible to write a macro to extend the range (Source range) of one of the lines ? I would also like to add a Data Label to the newly added point.
For e.g. If I have Line 1 graph only till 65, I want the macro to extend the range by one row to include 95 and also display a datalabel
Line 1 Line 2
I dont know whether I am trying to do too much with this macro. But if anyone can help me with this, it will be fantastic.
Thanks in advance