Graphing with "Empty" vs "Blank" Cells
- From: "WebColin" <WebColin@xxxxxxxxxx>
- Date: Sat, 22 Nov 2008 08:13:34 -0500
I am trying to create a line graph based on a table, where each cell within
that table has its value set by a condition. If there is not enough data, I
want a gap in the graph for that time period. Instead, I am getting 0 values
on the graph.
I currently have the condition set the cell value to "" if there is
insufficient data.
It's sort of like this (actual formula is much longer, but concept is the
same): =if(X1>mindatacount,Y1,"")
Where "mindatacount" is just the minimum number of data points, tracked in
row X.
And when I graph it, I want the graph to ignore cells that are blank (hence
the "" if the count is too small). But because they are not "Empty" it
treats them as Zero in the graph.
Is there a workaround? Is there any way in my condition to define the cell
as Empty if there isn't sufficient data or to make the graph treat Blank
cells the same as Empty cells?
Thanks for any help,
Colin
.
- Follow-Ups:
- RE: Graphing with "Empty" vs "Blank" Cells
- From: Shane Devenshire
- RE: Graphing with "Empty" vs "Blank" Cells
- Prev by Date: Re: Need help in generating a report.
- Next by Date: Re: find last part of text
- Previous by thread: Excel 2003 - Numbers vs text
- Next by thread: RE: Graphing with "Empty" vs "Blank" Cells
- Index(es):
Relevant Pages
|
