Plotting different length series in a chart

I have a series of data that extends for 12 months and another series that
extends for 4 months. Plan vs actual. The actual series continues at a zero
value after the data ends. Is there a way to chart only the 4 months on one
series while the full 12 months is charted on the other series?

Fill the empty cells in the short range with =NA() - will display as #N/A
and be ignored by chart

best wishes


--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Big Red" <BigRed@discussions.microsoft.com> wrote in message
news:F6A87C30-6AE3-4AC4-9C4E-8E3C3A4EC9CB@microsoft.com...
>I have a series of data that extends for 12 months and another series that
> extends for 4 months. Plan vs actual. The actual series continues at a
> zero
> value after the data ends. Is there a way to chart only the 4 months on
> one
> series while the full 12 months is charted on the other series?

Works great for missing data points too.

Thanks for the tip.

On Wed, 8 Dec 2004 15:53:11 -0400, "Bernard Liengme"
<bliengme@stfx.TRUENORTH.ca> wrote:

>=NA()

--
=================================================
Do you like wine? Do you live in South Florida?
Visit the MIAMI WINE TASTERS group at
http://groups.yahoo.com/group/miamiWINE
=================================================