Controlling a chart in a macro...

[SteveD]

Hi all,

Hope someone can help with this. In Excel 2007, I'm writing a macro to create several charts (column) that need to match what a designer has already built. I'm having a devil of a time finding the code I need to create parts of the chart. I've searched the web and this forum, but I must just not be asking the right things.

I can see everything I want to do in the format pop-up window when I right click on the charts in Excel, here is the path:

1) Format Minor Gridlines, Line Style, Dash Type, Rounded Dot
2) Format Axis, Axis Options, Major tick mark type, None
3) Format Axis, Axis Options, Position Axis, Between tick marks

Thanks for your help!

Steve

 

[SteveD]

ACK!

Pasted it in the wrong place. Thanks for pointing that out!