Macro + Graph

[pzamory]

Looking for help....

I would like to record a macro which will take columns A, B and E (from Sheet1) and create a graph which will appear on Sheet2.

Any thoughts?

Thank you.

 

[Andrew Poulsom]

Have you tried recording a macro while doing it manually? That should get you started.

 

[pzamory]

Macro

Would I cut/paste the graph into Sheet2? I'm not sure if the macro would record that.

 

[Andrew Poulsom]

You have the option to choose the target sheet at step 4 of the Chart Wizard.

 

[pzamory]

It works

Very nice, thanks a million.

 

[pzamory]

VB Editor help

One more item:

"Open the Visual Basic Editor, and make sure that your name is entered as a comment at the top of both the ProfitMargins and SalesColumnChart macros"

Any advice on how to do this?

 

[Andrew Poulsom]

Is this coursework?

 

[pzamory]

Yes

I missed the section on Visual Basic. I'm in the editor but can't figure out how to add a comment.

 

[pzamory]

Got it

I used the Help function and figured it out.... Thank you