title: Excel VBA: Which OLE/OCX control to use to display a chart in a form?
body: <p>I have to display a column chart in a user form in VBA. Exporting the chart to GIF and importing in a picture box works; but I cannot use it because the chart needs to be modified based on options chosen by the user from the same form. I have been searching and people have commented that default OLE/OCX controls provided by MS may be used. I cannot find an ActiveX which may do the trick. Does somebody know which controls to use and how to use them?</p>