Null values in Pivot Chart

  • Thread starter Thread starter Caroline
  • Start date Start date
C

Caroline

I searched on the internet and couldn't find what I was looking for, so I'm
trying here. I am working on a Pivot Chart in Access in which I used
conditional formatting like this:
http://peltiertech.com/Excel/Charts/ConditionalChart1.html
Everything works well with the conditional part, but then when I try to
format the data labels, I put #.### in the format section, which is what I
want for all of the data labels that are not null. However, this makes a data
label that just has a "." in it for all the null values. How do I get rid of
that? Is there a way to only put a data label only if the value is not null?

Thanks,
Caroline
 
You can actually specify up to 4 separate formats for a given field,
separating them with semicolons (;) as the list separator.

Each section contains the format specification for a different type of
number.

The first section is the format for positive numbers, the second is for
negative numbers, the format is for zero value and the fourth is for Null
values. For example, you could use the following custom Currency format:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
 
Thanks! That helps a lot. I tried just putting in "" as the format for the
null values and a little underline shows up in the data label but I can deal
with that.

Douglas J. Steele said:
You can actually specify up to 4 separate formats for a given field,
separating them with semicolons (;) as the list separator.

Each section contains the format specification for a different type of
number.

The first section is the format for positive numbers, the second is for
negative numbers, the format is for zero value and the fourth is for Null
values. For example, you could use the following custom Currency format:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Caroline said:
I searched on the internet and couldn't find what I was looking for, so I'm
trying here. I am working on a Pivot Chart in Access in which I used
conditional formatting like this:
http://peltiertech.com/Excel/Charts/ConditionalChart1.html
Everything works well with the conditional part, but then when I try to
format the data labels, I put #.### in the format section, which is what I
want for all of the data labels that are not null. However, this makes a
data
label that just has a "." in it for all the null values. How do I get rid
of
that? Is there a way to only put a data label only if the value is not
null?

Thanks,
Caroline
Click to expand...
Click to expand...
 
Back
Top