Embedding a chart in excel

Stephen Boulet Stephen.Boulet at no.spam.motorola.com
Thu Aug 21 18:17:24 EDT 2003


I'm having trouble scripting Excel to embed a chart from python.

Say I have created a sheet object and a workbook object, "xlSheet" and 
"xlBook".

Creating a chart in front of my sheet is as easy as:

xlSheet.Select()
xlChart = xlBook.Charts.Add()

Now how do I tell it to go embed itself in my sheet? In VBA, it might be 
something like:

xlChart.Location Where:=xlLocationAsObject, Name:=xlSheet.Name

Thanks.

(Is there a newsgroup/list with more of a focus on issues like this than 
c.l.py?)

-- Stephen





More information about the Python-list mailing list