| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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.charting
|
|||
|
|||
|
Data Labels
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: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data Labels
They still print with a white background.
"Andy Pope" wrote: 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: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data Labels
Then maybe David's suggestion (misc NG) regards Black and white print
option is more appropriate. Connie Martin wrote: They still print with a white background. "Andy Pope" wrote: 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: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data Labels
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. Connie "Andy Pope" wrote: Then maybe David's suggestion (misc NG) regards Black and white print option is more appropriate. Connie Martin wrote: They still print with a white background. "Andy Pope" wrote: 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: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data Labels
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: 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. Connie "Andy Pope" wrote: Then maybe David's suggestion (misc NG) regards Black and white print option is more appropriate. Connie Martin wrote: They still print with a white background. "Andy Pope" wrote: 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: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| 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) | |||
Linear Mode
