Hi all. I have a X-coordinate and some Y-coordinate and want to make a chart (with macro).
X -5 -4 -3 -2 -1 0 1 2 3 4 5 Y2 -5,307692308 -4,076923077 -2,846153846 -1,615384615 -0,384615385 0,846153846 2,076923077 3,307692308 4,538461538 5,769230769 7 Y1 -4,2 -2,6 -1 0,6 2,2 3,8 5,4 7 8,6 10,2 11,8 What I need is to select the X column - then hold down CTRL and then select the Y2 and Y1 columns - and then make a chart. How to do that with macro? Best regards -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts