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

Oops! Should've posted this in Excel Charts. I will do so now.

quot;Connie Martinquot; 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

Turn off Bamp;W option in File, Page Setup, Sheets -- if it is on.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Connie Martinquot; gt; wrote in message ...
gt; Oops! Should've posted this in Excel Charts. I will do so now.
gt;
gt; quot;Connie Martinquot; wrote:
gt;
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
It is off. I even selected quot;nonequot; for colour instead of gray, as someone
suggested. It shows gray on the screen, but in print preview the data labels
are with a white background and they print white.

quot;David McRitchiequot; wrote:

gt; Turn off Bamp;W option in File, Page Setup, Sheets -- if it is on.
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Connie Martinquot; gt; wrote in message ...
gt; gt; Oops! Should've posted this in Excel Charts. I will do so now.
gt; gt;
gt; gt; quot;Connie Martinquot; 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;

Hi Connie,
See if this helps

XL2000: Unexpected Font or Color Formatting Applied to Chart
support.microsoft.com/kb/211677
---HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages:
www.mvps.org/dmcritchie/excel/excel.htmSearch Page: www.mvps.org/dmcritchie/excel/search.htm quot;Connie Martinquot;
gt; wrote in message ...
gt; It is off. I even selected quot;nonequot; for colour instead of gray, as someone
gt; suggested. It shows gray on the screen, but in print preview the data labels
gt; are with a white background and they print white.
gt;
gt; quot;David McRitchiequot; wrote:
gt;
gt; gt; Turn off Bamp;W option in File, Page Setup, Sheets -- if it is on.
gt; gt;
gt; gt; ---
gt; gt; HTH,
gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt;
gt; gt; quot;Connie Martinquot; gt; wrote in message
...
gt; gt; gt; Oops! Should've posted this in Excel Charts. I will do so now.
gt; gt; gt;
gt; gt; gt; quot;Connie Martinquot; 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;
That does not appear to help either. 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. Thank you for your input.

quot;David McRitchiequot; wrote:

gt; Hi Connie,
gt; See if this helps
gt;
gt; XL2000: Unexpected Font or Color Formatting Applied to Chart
gt; support.microsoft.com/kb/211677
gt; ---HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages:
gt; www.mvps.org/dmcritchie/excel/excel.htmSearch Page: www.mvps.org/dmcritchie/excel/search.htm quot;Connie Martinquot;
gt; gt; wrote in message ...
gt; gt; It is off. I even selected quot;nonequot; for colour instead of gray, as someone
gt; gt; suggested. It shows gray on the screen, but in print preview the data labels
gt; gt; are with a white background and they print white.
gt; gt;
gt; gt; quot;David McRitchiequot; wrote:
gt; gt;
gt; gt; gt; Turn off Bamp;W option in File, Page Setup, Sheets -- if it is on.
gt; gt; gt;
gt; gt; gt; ---
gt; gt; gt; HTH,
gt; gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt; gt;
gt; gt; gt; quot;Connie Martinquot; gt; wrote in message
gt; ...
gt; gt; gt; gt; Oops! Should've posted this in Excel Charts. I will do so now.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Connie Martinquot; wrote:
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;

I'm not familiar with specific printers, but good that you included that in case anyone wants that information.
Possibly Gray needs color unless you have only black in the printer.
I'd also check the printer options for the specific printers..quot;Connie Martinquot; gt; wrote...
gt; That does not appear to help either. What I discovered is that if I send
gt; this chart to print on the colour printer, the labels do not have a white
gt; background, but if I send the chart to print on the non-colour printer (HP
gt; 6L) it has white background. So, since I have the option, I will print them
gt; in colour and be done with it. They don't really need to be in colour
gt; because there are only two colours involved and are easily distinguishable in
gt; black/white/gray tones. However, I will stick to colour. There must be a
gt; problem with the printer. Thank you for your input.