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


    Rachit,


    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?


    Jim

    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!

Register Yourself Login