Re: making a chart in Excel 2004?
Re: making a chart in Excel 2004?
- Subject: Re: making a chart in Excel 2004?
- From: David Wignall <email@hidden>
- Date: Wed, 02 Jun 2004 21:05:50 +1200
on 2/06/2004 3:17 PM, trinko at email@hidden wrote:
>
i can make a chart object instance. i can get the chart instance in
>
that chart object instance. i have no idea how to put data into the
>
chart. you can't create a chart group, although there seems to be
>
one in the chart instance, and you can't create a new series which
>
seems to be the actual plotted data.
<snip>
>
has anyone figured out how to make a simple line chart? any help
>
would be appreciated. thanks.
Given
tell application "Microsoft Excel"
set objChart to chart of chart sheet ("Chart1")
...
then I would expect
make new series at objChart with properties {name:"New", series
values:{20, 20, 20}}
to work, but it don't: can't make a series. The objChart variable seems
relevant; I can get the properties of existing series. The equivalent VBA
code, assuming 1 existing series, would be
objChart.SeriesCollection.NewSeries
With objChart.SeriesCollection(2)
.Values = varSomeArrayOfValues
.Name = "Total With Discounts"
End With
so I tried
make new series at series collection of objChart with properties
{name:"New", series values:{20, 20, 20}}
but again 'can't make a series' anyone see what I'm missing?
--
Dave
_______________________________________________
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.