Windows. Active X objects. Excel Chart

Question

i need to find Excel active X object mschart.ocx or mschrt20.ocx.

Where are they laying?

Thanks!

P.S:

Am i right, that they can help me to use active x chart: msdn

Thanks!

Answer 1

You don't need to know about the OCX to use this control in Excel, support is built-in.

Simply add a chart to your worksheet.

Charts are also exposed in VBA for programmatic use.

As is often the case, if you record a macro while inserting a chart, you will get some code that will point you in the right direction.

Worksheets have a "ChartObjects" collection that you can work with.

You can programmatically add a chart to a worksheet with something like:

Set myChart = ActiveSheet.Shapes.AddChart.Chart

---

UPDATE 2012-05-18: Following up on the comment below. I think that charting is embedded in one of the Excel DLL's.

You can get the chart controls from Microsoft:

• Microsoft Chart Controls Add-on for Microsoft Visual Studio 2008
• Microsoft Chart Controls for Microsoft .NET Framework 3.5

(GRRR! I can only put 2 links in here!! I'll add another comment for the other 2)