vba - Creating Diagram from Excel Using VB -

sorry can't embed images, have links instead (... can post 2 links. have removed http:// substring of links).

i looking take .csv file (really, file, generating myself), , create visio (2010) diagram out of it. have imported excel sheet visio, , can create rough diagrams, not enough. i'm trying create. here following tactics have tried, prefer vb method, whatever works works:

data graphics: closest i've gotten solution. create shapes , can put data in it. problem is, style of display available limited, can see here (imgur.com/cltlcxk). after importing excel sheet, had drag , drop create these shapes. closest have gotten here. however, need outside box (or container, aesthetic reasons). (some information here [support.office.com/en-us/article/enhance-your-data-with-data-graphics-45af64a4-1dcb-4463-9a7e-67709786181c])

vb: have been using (msdn.microsoft.com/en-us/library/office/ff959245%28v=office.14%29.aspx). have ran of example code, lost. have run of example code 1 have gotten work useless me. also, don't see api methods add data these diagrams!

so how done?

i approach problem first defining or finding visio masters data i'm drawing page. in case looks you'd want master foo items, , 1 bar items.

so you'd step through bars, within each bar you'd have 1 or more foos. each foo, drop master out, , set text of shape want in blue foo section (maybe grouped sub-shape foo master), , text in white body.

when stepping through bars, you'd have drop out bar shape , position/size contain foos.