Re: excel 2004 chart question
Re: excel 2004 chart question
- Subject: Re: excel 2004 chart question
- From: Paul Berkowitz <email@hidden>
- Date: Sun, 23 May 2004 18:25:20 -0700
On 5/23/04 4:06 PM, "trinko" <email@hidden> wrote:
>
You apparently can't make a chart object and you can't make a chart
>
object at the end of the chart objects of the current worksheet.
>
anyone know how to make a chart? thanks.
You certainly can make a chart object. You have to peruse the dictionary to
see where to make it. It's not an element of 'application' so you can't make
it out of thin air. But of you look at 'sheet' and 'worksheet', you'll see
they both have 'chart object' as an element. So this works (up to a point):
tell application "Microsoft Excel"
set chartObj to make new chart object at active sheet with properties
{height:120.0, left position:35.0, rounded corners:false, shadow:true,
top:15, width:75.0}
set theChart to chart of chartObj
set chart type of theChart to column clustered
set bar shape of theChart to cylinder
end tell
Since I don't actually know anything whatsoever about Excel charts, I'm not
sure where to go from there - how to get significant data into the chart. I
notice there's a 'data table object' property of chart of class 'data table'
whose properties can be set but they don't contain anything representing raw
data. Perhaps the very fact that the chart object can be made to belong to
the sheet, or a sector of the sheet, will automatically give it the data
contained in that range. You probably know all about that aspect already, or
could find it in the VB Help.
I see also that a workbook can have chartsheets as elements, and a
chartsheet has a chart property.
--
Paul Berkowitz
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.