simple question, hopefully a simple answer.

is it possible to do a custom 'drawing' in vba? e.g. to a '.wmf' file?

the reason is i need to create a custom chart to do some analysis and the standard types (including pivots) in excel & access don't work.

what i need to do is draw lines, write simple text & draw rectangles etc, nothing fancy. then to show the .wmf in a picture box (that bit i can do).

I'm looking for the wmf route to allow me to print the chart / export it without too much effort. working with a bmp would be ok as well though.

question is: is this possible in VBA? I know its possible in vb.net but at the mo I've been informed i'm stuck with VBA...