Graphs in VBA

[Roonaldez]

Hi,

Is anyone able to point me towards a tutorial that can teach me how to draw variable range dual axis graphs in vba? I have read through a few, but still not getting the structure/meaning of the code in the examples.

Thank you

 

[SkipVought]

Turn on your macro recorder and record actually doing what you want to do.

Post back with your recorded code, if you have trouble customizing.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[Roonaldez]

I can record a 'normal' graph...that's reltively easy, but I want to set it for a variable range rather than a fixed range...Also, the data is not contiguous and I would like one bar and one line rather than two of the same...thanks.

 

[SkipVought]

"...I want to set it for a variable range ..."

"...Also, the data is not contiguous and I would like one bar and one line rather than two of the same..."

does not change my suggestion. Just define the source data.

Post back with your code AND a detailed description of the non-contiguous data range.

Please be CLEAR, CONCISE and COMPLETE.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]