Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2005

Tip: Looking for answers? Try searching our database.

Data Labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Connie Martin - 29 Dec 2005 19:52 GMT
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 - 29 Dec 2005 20:01 GMT
Hi,

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

Cheers
Andy

> 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

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Connie Martin - 29 Dec 2005 21:09 GMT
They still print with a white background.

> Hi,
>
[quoted text clipped - 8 lines]
> > gray but it remains white when I print the chart.  I'm obviously doing
> > something wrong.  Any suggesions?     Connie
Andy Pope - 29 Dec 2005 21:17 GMT
Then maybe David's suggestion (misc NG) regards Black and white print
option is more appropriate.

> They still print with a white background.
>
[quoted text clipped - 10 lines]
>>>gray but it remains white when I print the chart.  I'm obviously doing
>>>something wrong.  Any suggesions?     Connie

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Connie Martin - 30 Dec 2005 15:27 GMT
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

> Then maybe David's suggestion (misc NG) regards Black and white print
> option is more appropriate.
[quoted text clipped - 13 lines]
> >>>gray but it remains white when I print the chart.  I'm obviously doing
> >>>something wrong.  Any suggesions?     Connie
Andy Pope - 30 Dec 2005 15:57 GMT
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

> 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
[quoted text clipped - 22 lines]
>>>>>gray but it remains white when I print the chart.  I'm obviously doing
>>>>>something wrong.  Any suggesions?     Connie

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.