Re: plotting "empty" cells that contain a formula that has returned a blank
From: JImCC (anonymous_at_discussions.microsoft.com)
Date: 07/02/04
- Next message: rlo: "Org Charts in Excel 2000"
- Previous message: John: "Prob. when viewing my XL graph thru internet..."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Jul 2004 06:40:52 -0700
Yes the NA()does work.
But is therea way for the series line to be broken.
for example:
I am trending a series over a priod of time say day 1 to
4. on the 3 day there is no data.
I would like the series to have no data there and the x-
axis still to have the date day 3.
Is this possible. Using NA() conects the series line from
day 2 to day 4?
Hopeful?
>-----Original Message-----
>Instead of return a blank (" " or "") result, return a NA
().
>
>If you need a null string ("") for subsequent
calculations or for
>aesthetic purposes, create a 2nd dummy range that has NA
() instead of
>"".
>
>Plot the range with the NA()s
>
>--
>Regards,
>
>Tushar Mehta
>www.tushar-mehta.com
>Excel, PowerPoint, and VBA add-ins, tutorials
>Custom MS Office productivity solutions
>
>In article <2313501c45de7$46672590$a001280a@phx.gbl>,
>anonymous@discussions.microsoft.com says...
>> Cells that appear empty, but contain a formula that has
>> returned a blank, when plotted on a line chart, plot as
>> ZEROS. This is in spite of setting tools, options,
charts
>> to "zero values not plotted". Does anyone know a way
round
>> this, please.
>>
>> thanks
>> Bob Farey
>>
>.
>
- Next message: rlo: "Org Charts in Excel 2000"
- Previous message: John: "Prob. when viewing my XL graph thru internet..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
