ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data Labels (https://www.excelbanter.com/charts-charting-excel/62375-data-labels.html)

Connie Martin

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

Andy Pope

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

Connie Martin

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


Andy Pope

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

Connie Martin

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


Andy Pope

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


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com