View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Problem with Datalabel in Stacked bar charts

Is your document protected? When I bring up the box Format Data Labels and
click Font I go down to Background. Then there is a box to choose automatic,
transparent, or opaque. I can set transparent there.


"Shyam" wrote:

BJ,
Thanks for posting your comment. I am using Microsoft Excel 2002 ver.
When I right click the datalabel, I can see the background color set as
automatic and I am not able to see any "transparent" check box or something
like that.

Please let me know is there any other to fix this issue..

"BJ" wrote:

Have you tried going to datalabels - font - background - and changing it to
transparent?

"Shyam" wrote:

Hi,
I have a stacked bar chart and over the chart I have data labels.
Problem is: When I print my chart in printer, my datalabels are
being displayed in a square box with white color background.
I do not want any background or border for my data label.
I even checked the datalabel properties. While viewing the chart,
the data label is good but when printing I can see a white background for
data labels.

Can someone help me in fixiing this.