Also, when you close and re-open your workbook, it starts over from Row 2. If this is not what you want, and you want it to continue from where you left off, let me know and I'll make changes to the code when I get a chance. Not sure when I'll be able to get to it, though. Also, what if you reach the last row of the worksheet? Do you want to continue in the next columns? Something else?
Domenic,
Sorry for my misinterpretation, my confusion
His codes worked perfectly. There are no problems.
I was wrong to select the range of cells with data and so did not show all the rows on the chart.
There was no problem with the line limit, I was wrong.
You had correctly understood what I need:
I need 3 versions of the code:
1a version If I re-start the work continues next cell (row) - continue from where I am left off, same column. (Continues segment lines) I will continue the Drawing in same series.
2a version if I re-open the workbook Jump one cell (row) with yellow and continue next cell after yellow, same column (start new segment on the chart) I will continue the drawing in next same series.
3rd version "When you close and re-open your workbook, it starts over from Row 2." (Re-start of code) i will clean the colum and run the code. I will clena Drawing and make new drawing.
all versions with " if you reach the last row of the worksheet Do you want to continue in the next columns?" YES, YES.
All version with a line of code to clear the old original points of original chart (each point), (i am will put apostrophes in this line to disabled this line of code if i not need delete the point and delete the QuotationMarks (apostrophes) if i need delete the point of chart). The code will Clear the point exactly afther copy the point to new column of new chart. MouseOver will delete the point of old chart if i need.
I am going to put apostrophes in this line to disable this line of code if I do not need to delete the point and delte the apostrophes if I need to delete the point of chart ). The code will clear the point exactly afther copy the point to new column of new chart. MouseOver will delete the point of old chart if i need.
1one Old original approach version with continues into next columns at ech series (moving mouse outside the chart or esc key) is one plus option to i have more options to future, including all new changes.
i will make a screenshot to you.
thanks!