software

Excel 2000: The data labels are showing with a white background on a gray
plot area. I have formatted the data label background to the same colour of
gray but it remains white when I print the chart. I'm obviously doing
something wrong. Any suggesions? Connie

Hi,

What happens if you set the data labels area colour to None rather than
the colour of the plot area?

Cheers
Andy

Connie Martin wrote:
gt; Excel 2000: The data labels are showing with a white background on a gray
gt; plot area. I have formatted the data label background to the same colour of
gt; gray but it remains white when I print the chart. I'm obviously doing
gt; something wrong. Any suggesions? Connie

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

They still print with a white background.

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; What happens if you set the data labels area colour to None rather than
gt; the colour of the plot area?
gt;
gt; Cheers
gt; Andy
gt;
gt; Connie Martin wrote:
gt; gt; Excel 2000: The data labels are showing with a white background on a gray
gt; gt; plot area. I have formatted the data label background to the same colour of
gt; gt; gray but it remains white when I print the chart. I'm obviously doing
gt; gt; something wrong. Any suggesions? Connie
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

Then maybe David's suggestion (misc NG) regards Black and white print
option is more appropriate.

Connie Martin wrote:
gt; They still print with a white background.
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Hi,
gt;gt;
gt;gt;What happens if you set the data labels area colour to None rather than
gt;gt;the colour of the plot area?
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;Connie Martin wrote:
gt;gt;
gt;gt;gt;Excel 2000: The data labels are showing with a white background on a gray
gt;gt;gt;plot area. I have formatted the data label background to the same colour of
gt;gt;gt;gray but it remains white when I print the chart. I'm obviously doing
gt;gt;gt;something wrong. Any suggesions? Connie
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

I want to thank you for trying to resolve this problem. What I discovered is
that if I send this chart to print on the colour printer, the labels do not
have a white background, but if I send the chart to print on the non-colour
printer (HP 6L) it has white background. So, since I have the option, I will
print them in colour and be done with it. They don't really need to be in
colour because there are only two colours involved and are easily
distinguishable in black/white/gray tones. However, I will stick to colour.
There must be a problem with the printer. Conniequot;Andy Popequot; wrote:

gt; Then maybe David's suggestion (misc NG) regards Black and white print
gt; option is more appropriate.
gt;
gt; Connie Martin wrote:
gt; gt; They still print with a white background.
gt; gt;
gt; gt; quot;Andy Popequot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;Hi,
gt; gt;gt;
gt; gt;gt;What happens if you set the data labels area colour to None rather than
gt; gt;gt;the colour of the plot area?
gt; gt;gt;
gt; gt;gt;Cheers
gt; gt;gt;Andy
gt; gt;gt;
gt; gt;gt;Connie Martin wrote:
gt; gt;gt;
gt; gt;gt;gt;Excel 2000: The data labels are showing with a white background on a gray
gt; gt;gt;gt;plot area. I have formatted the data label background to the same colour of
gt; gt;gt;gt;gray but it remains white when I print the chart. I'm obviously doing
gt; gt;gt;gt;something wrong. Any suggesions? Connie
gt; gt;gt;
gt; gt;gt;--
gt; gt;gt;
gt; gt;gt;Andy Pope, Microsoft MVP - Excel
gt; gt;gt;www.andypope.info
gt; gt;gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

Thanks for posting back with the info.
It might be worth checking on the suppliers site that you have the
latest print drivers.

Cheers
Andy

Connie Martin wrote:
gt; I want to thank you for trying to resolve this problem. What I discovered is
gt; that if I send this chart to print on the colour printer, the labels do not
gt; have a white background, but if I send the chart to print on the non-colour
gt; printer (HP 6L) it has white background. So, since I have the option, I will
gt; print them in colour and be done with it. They don't really need to be in
gt; colour because there are only two colours involved and are easily
gt; distinguishable in black/white/gray tones. However, I will stick to colour.
gt; There must be a problem with the printer. Connie
gt;
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Then maybe David's suggestion (misc NG) regards Black and white print
gt;gt;option is more appropriate.
gt;gt;
gt;gt;Connie Martin wrote:
gt;gt;
gt;gt;gt;They still print with a white background.
gt;gt;gt;
gt;gt;gt;quot;Andy Popequot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;Hi,
gt;gt;gt;gt;
gt;gt;gt;gt;What happens if you set the data labels area colour to None rather than
gt;gt;gt;gt;the colour of the plot area?
gt;gt;gt;gt;
gt;gt;gt;gt;Cheers
gt;gt;gt;gt;Andy
gt;gt;gt;gt;
gt;gt;gt;gt;Connie Martin wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;gt;Excel 2000: The data labels are showing with a white background on a gray
gt;gt;gt;gt;gt;plot area. I have formatted the data label background to the same colour of
gt;gt;gt;gt;gt;gray but it remains white when I print the chart. I'm obviously doing
gt;gt;gt;gt;gt;something wrong. Any suggesions? Connie
gt;gt;gt;gt;
gt;gt;gt;gt;--
gt;gt;gt;gt;
gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;gt;gt;www.andypope.info
gt;gt;gt;gt;
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info