(Msg. 1) Posted: Tue Oct 06, 2009 6:13 am
Post subject: Surpressing plot of blank cells Archived from groups: microsoft>public>excel>charting (more info?)
I'm creating a line chart plot using Excel 2007. The data range for plot
lines contains some blank cells. These blank cells get plotted as zero
points.
How do I change this behavior to plot only points that have values and to
leave the blank cells unplotted?
(Msg. 2) Posted: Tue Oct 06, 2009 12:05 pm
Post subject: Re: Surpressing plot of blank cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
If they are truly blank then check the plot empty cells setting via.
Select Data > Hidden and Empty cells.
If the Cells in fact contain formula then use NA() instead of "". This will
suppress the data marker but will not break the line.
Alternatively use Autofilter to hide unwanted rows.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"John" <John.RemoveThis@discussions.microsoft.com> wrote in message
news:49F3936C-DB45-497F-A77D-4F9F779F1CC8@microsoft.com...
> I'm creating a line chart plot using Excel 2007. The data range for plot
> lines contains some blank cells. These blank cells get plotted as zero
> points.
>
> How do I change this behavior to plot only points that have values and to
> leave the blank cells unplotted?
>
> I appreciate your help, -John
(Msg. 3) Posted: Wed Oct 07, 2009 1:43 pm
Post subject: Re: Surpressing plot of blank cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The cells I am plotting are non-empty, they contain the formula
=IF('Monthly Input'!I32<>"",'Monthly Input'!I32,"")
that picks up none empty cells from another sheet. Checking the "Plot empty
cells" option does not surpress the plotting of these cells as zero points.
How do I change my formula to cause zero points to not plot?
I appreciate your help, -John
"Andy Pope" wrote:
> Hi,
>
> If they are truly blank then check the plot empty cells setting via.
> Select Data > Hidden and Empty cells.
>
> If the Cells in fact contain formula then use NA() instead of "". This will
> suppress the data marker but will not break the line.
>
> Alternatively use Autofilter to hide unwanted rows.
>
> Cheers
> Andy
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info > "John" <John RemoveThis @discussions.microsoft.com> wrote in message
> news:49F3936C-DB45-497F-A77D-4F9F779F1CC8@microsoft.com...
> > I'm creating a line chart plot using Excel 2007. The data range for plot
> > lines contains some blank cells. These blank cells get plotted as zero
> > points.
> >
> > How do I change this behavior to plot only points that have values and to
> > leave the blank cells unplotted?
> >
> > I appreciate your help, -John
>
>
(Msg. 4) Posted: Wed Oct 07, 2009 7:05 pm
Post subject: Re: Surpressing plot of blank cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=IF('Monthly Input'!I32<>"",'Monthly Input'!I32,NA())
--
David Biddulph
"John" <John.RemoveThis@discussions.microsoft.com> wrote in message
news:EB3D147D-B608-4C9A-9F1A-9687C96A03FA@microsoft.com...
> The cells I am plotting are non-empty, they contain the formula
> =IF('Monthly Input'!I32<>"",'Monthly Input'!I32,"")
> that picks up none empty cells from another sheet. Checking the "Plot
> empty
> cells" option does not surpress the plotting of these cells as zero
> points.
>
> How do I change my formula to cause zero points to not plot?
>
> I appreciate your help, -John
>
> "Andy Pope" wrote:
>
>> Hi,
>>
>> If they are truly blank then check the plot empty cells setting via.
>> Select Data > Hidden and Empty cells.
>>
>> If the Cells in fact contain formula then use NA() instead of "". This
>> will
>> suppress the data marker but will not break the line.
>>
>> Alternatively use Autofilter to hide unwanted rows.
>>
>> Cheers
>> Andy
>>
>> --
>>
>> Andy Pope, Microsoft MVP - Excel
>> http://www.andypope.info >> "John" <John.RemoveThis@discussions.microsoft.com> wrote in message
>> news:49F3936C-DB45-497F-A77D-4F9F779F1CC8@microsoft.com...
>> > I'm creating a line chart plot using Excel 2007. The data range for
>> > plot
>> > lines contains some blank cells. These blank cells get plotted as zero
>> > points.
>> >
>> > How do I change this behavior to plot only points that have values and
>> > to
>> > leave the blank cells unplotted?
>> >
>> > I appreciate your help, -John
>>
>>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office