A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Disappearing Data Label in chart



 
 
Thread Tools Display Modes
  #1  
Old October 27th, 2009, 05:15 PM posted to microsoft.public.excel.charting
Meenie
external usenet poster
 
Posts: 270
Default Disappearing Data Label in chart

I have Excel 2003
I have a clustered column chart that shows the date that a monthly report
was turned in from each unit. I put data labels on each column that show the
week number and the date, so the chart for October would show:
"Wk1
10/6"
or
Wk1
10/22
but for one unit, the data label has disappeared. By clicking around I can
find the box for the unit up at the top of the chart but if I pull it down to
the position I want it in (and have also found the option for it and chose
"center" ) when I click off of it it disappears again and is invisible at the
top of the chart again!
Any idea how I can fix this? I have done "chart options" / "data labals" and
made sure everything is checked correctly, and clicked on the single column
and clicked on "format" / "data labels" and made sure everything is checked,
but nothing seems to work
any suggestions would be greatly appreciated as this is very annoying.
thanks, Meenie

  #2  
Old October 28th, 2009, 01:17 PM posted to microsoft.public.excel.charting
Meenie
external usenet poster
 
Posts: 270
Default Disappearing Data Label in chart

No one else has any ideas either, huh?

"Meenie" wrote:

I have Excel 2003
I have a clustered column chart that shows the date that a monthly report
was turned in from each unit. I put data labels on each column that show the
week number and the date, so the chart for October would show:
"Wk1
10/6"
or
Wk1
10/22
but for one unit, the data label has disappeared. By clicking around I can
find the box for the unit up at the top of the chart but if I pull it down to
the position I want it in (and have also found the option for it and chose
"center" ) when I click off of it it disappears again and is invisible at the
top of the chart again!
Any idea how I can fix this? I have done "chart options" / "data labals" and
made sure everything is checked correctly, and clicked on the single column
and clicked on "format" / "data labels" and made sure everything is checked,
but nothing seems to work
any suggestions would be greatly appreciated as this is very annoying.
thanks, Meenie

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.