Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data labels
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data labels
Oops! Should've posted this in Excel Charts. I will do so now.
"Connie Martin" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data labels
Turn off B&W option in File, Page Setup, Sheets -- if it is on.
--- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Connie Martin" wrote in message ... Oops! Should've posted this in Excel Charts. I will do so now. "Connie Martin" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data labels
It is off. I even selected "none" 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. "David McRitchie" wrote: Turn off B&W option in File, Page Setup, Sheets -- if it is on. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Connie Martin" wrote in message ... Oops! Should've posted this in Excel Charts. I will do so now. "Connie Martin" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data labels
Hi Connie,
See if this helps XL2000: Unexpected Font or Color Formatting Applied to Chart http://support.microsoft.com/kb/211677 ---HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: http://www.mvps.org/dmcritchie/excel/search.htm "Connie Martin" wrote in message ... It is off. I even selected "none" 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. "David McRitchie" wrote: Turn off B&W option in File, Page Setup, Sheets -- if it is on. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Connie Martin" wrote in message ... Oops! Should've posted this in Excel Charts. I will do so now. "Connie Martin" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data labels
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. "David McRitchie" wrote: Hi Connie, See if this helps XL2000: Unexpected Font or Color Formatting Applied to Chart http://support.microsoft.com/kb/211677 ---HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: http://www.mvps.org/dmcritchie/excel/search.htm "Connie Martin" wrote in message ... It is off. I even selected "none" 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. "David McRitchie" wrote: Turn off B&W option in File, Page Setup, Sheets -- if it is on. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Connie Martin" wrote in message ... Oops! Should've posted this in Excel Charts. I will do so now. "Connie Martin" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data labels
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.. "Connie Martin" wrote... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
"Bring to Front" Data Labels? | Charts and Charting in Excel | |||
Is there a way of attaching data labels from a text range to dat. | Charts and Charting in Excel | |||
VBA to change size of data labels? | Charts and Charting in Excel | |||
Using data as data labels | Excel Discussion (Misc queries) |