ActiveX Chart Properties in Excel 2000
 

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