Re: copy {""} to end of list
Re: copy {""} to end of list
- Subject: Re: copy {""} to end of list
- From: David Wignall <email@hidden>
- Date: Mon, 18 Jul 2005 09:16:17 +1200
on 18/07/2005 3:08 AM, Robert Poland at email@hidden wrote:
> Hi,
Hello
> I'm working on graph creation from an excel worksheet.
>
> Some of the lines of the graph consist of
> intermittent data and I wish for the lines to go
> from data point to data point without dropping to
> zero.
What you're after is actually a property of the chart rather than something
you fiddle with in your data. With XL2004 you would say something like
tell active chart to set (display blanks as) to interpolated
whereas in Excel X for Mac you would say
set DisplayBlanksAs of ActiveChart to xlInterpolated
--
Dave
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden