Line Chart

Thank you for trying to help. 1. I can't replace the cells with =NA()
because these cells have a formulas in them waiting for data to be entered to
calculate the formula.
I check the tools idea - but everythings appears to be as it should be.
Empty cells -
"not plotted" is checked and "Plot visual cells only" is checked. Do you
have any other ideas?

Aurora

"Bernard Liengme" wrote:

> Replace the blank cells with =NA() which displays as #N/a but is ignored by
> nchart
> OR
> Select chart; use Tools | Options; open Chart tab; specify what is to happen
> to empty cells
> best wishes
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Aurora" <Aurora@discussions.microsoft.com> wrote in message
> news:EE2CD813-23FF-4F2F-8705-CF209699393B@microsoft.com...
> >I am using Excel 2000
> > When I create Line Charts - usually for a year's time frame, my last part
> > of
> > the line (tail) on the chart goes directly to the bottom of the chart.
> > For
> > example: My line goes up and down for jan, feb, mar, (per the data) but
> > because there is no data for apr, the line goes directly to the bottom of
> > the
> > graph (0) at apr. I understand why this happens, but someone told me
> > there
> > is a way to stop this line at the end of the data without the tail hanging
> > down. I know that I could just highlight just the cells with data. but
> > this
> > in turn stretches my time frame (jan,feb& mar) across the whole chart
> > instead of showing the whole year (jan - dec). Does anyone know how to
> > get
> > rid of just the tail on the chart? I know this is a small thing, but it
> > bugs
> > some people around here. I would certainly appreciate any help someone
> > can
> > give me.
> >
> > Aurora
> >
> >
>
>
>

A cell with a formula is NOT empty even if nothing is displayed.

If your formula is something like =IF(test, math_expression, ""),
change it to =IF(test, math_expression, NA()),
Let me know if this helps
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Aurora" <Aurora@discussions.microsoft.com> wrote in message
news:7A3F7658-E37F-4074-B721-4DE585C56F79@microsoft.com...
> Thank you for trying to help. 1. I can't replace the cells with =NA()
> because these cells have a formulas in them waiting for data to be entered
> to
> calculate the formula.
> I check the tools idea - but everythings appears to be as it should be.
> Empty cells -
> "not plotted" is checked and "Plot visual cells only" is checked. Do you
> have any other ideas?
>
> Aurora
>
> "Bernard Liengme" wrote:
>
>> Replace the blank cells with =NA() which displays as #N/a but is ignored
>> by
>> nchart
>> OR
>> Select chart; use Tools | Options; open Chart tab; specify what is to
>> happen
>> to empty cells
>> best wishes
>>
>> --
>> Bernard V Liengme
>> www.stfx.ca/people/bliengme
>> remove caps from email
>>
>> "Aurora" <Aurora@discussions.microsoft.com> wrote in message
>> news:EE2CD813-23FF-4F2F-8705-CF209699393B@microsoft.com...
>> >I am using Excel 2000
>> > When I create Line Charts - usually for a year's time frame, my last
>> > part
>> > of
>> > the line (tail) on the chart goes directly to the bottom of the chart.
>> > For
>> > example: My line goes up and down for jan, feb, mar, (per the data)
>> > but
>> > because there is no data for apr, the line goes directly to the bottom
>> > of
>> > the
>> > graph (0) at apr. I understand why this happens, but someone told me
>> > there
>> > is a way to stop this line at the end of the data without the tail
>> > hanging
>> > down. I know that I could just highlight just the cells with data. but
>> > this
>> > in turn stretches my time frame (jan,feb& mar) across the whole chart
>> > instead of showing the whole year (jan - dec). Does anyone know how to
>> > get
>> > rid of just the tail on the chart? I know this is a small thing, but
>> > it
>> > bugs
>> > some people around here. I would certainly appreciate any help someone
>> > can
>> > give me.
>> >
>> > Aurora
>> >
>> >
>>
>>
>>