I have lots of data located in 2 coulumns of a worksheet named "Result" at C6:C1000 and D6:D1000. I want to create a scatter plot in new worksheet named "Chart" using a macro. How can i do it?? Please also provide comments in the macro.
Don’t have an account yet? Register yourself now and be a part of our community!