Hi Eric,

What do you mean by "(via ActiveX)"?
Are you programming in the Excel VBA?
And where is the chart object lie in?
Is the chart you want to change in a sheet?
If so, you can do it via the ChartObject and Chart?
1. Resize Chart Object (Stretch out the entire chart both
horizontally and vertically)
Sub Test()
Dim co As ChartObject
Set co = Sheet1.ChartObjects(1)
co.Height = 100
co.Width = 100
Dim ss As Series
Set ss = ActiveChart.SeriesCollection(1)
ss.ChartType = xl3DArea
End Sub
2. Add Data Table to the Chart
3. Get Access to Series of Data in a Chart and be able to
Change the Chart Type for that Series Only
It seems that you want to create a dynamic chart.

Here are some links about creating dynamic Chart.
146055 Using Visual Basic to Create a Chart Using a Dynamic Range
http://support.microsoft.com/?id=146055
185177 XL98: How to Create a Dynamic Chart by Using Visual Basic
http://support.microsoft.com/?id=185177
193249 XL98: Using Visual Basic to Create a Chart Using a Dynamic Range
http://support.microsoft.com/?id=193249



Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
Content-Class: urn:content-classes:message
From: "Eric Kopsch"
Sender: "Eric Kopsch"
Subject: ActiveX Chart Properties in Excel 2000
Date: Thu, 25 Sep 2003 08:21:05 -0700
Lines: 12
Message-ID:
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcODeKNsPfOEFv/iSrG0v07u4g/gRA==
Newsgroups: microsoft.public.excel.programming
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:418870
NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
X-Tomcat-NG: microsoft.public.excel.programming

I wanted to know how to get access programmatically (via
ActiveX) to Chart Properties/Methods in Excel.
Specifically, I have a need for the following:

1. Resize Chart Object (Stretch out the entire chart both
horizontally and vertically)
2. Add Data Table to the Chart
3. Get Access to Series of Data in a Chart and be able to
Change the Chart Type for that Series Only

Thanks for any assistance,
Eric