Chart In A Macro

  • 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.

  • Re: Chart In A Macro


    I seriously recommend that you RECORD a macro of you creating the chart first. Then, after you review the code, post any questions regarding improvements, etc. because, how do you know that won't work if you don't try it first?


  • Re: Chart In A Macro

    Actually i am working on a analysis project and the file would not be present initially.. its only after 5-6 steps of analysis that the required data is generated (It involves many worksheet to be created and deleted). So it is not possible to record a macro for myself.. So can you help me now?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!