ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Disappearing Data Label in chart (https://www.excelbanter.com/charts-charting-excel/246737-disappearing-data-label-chart.html)

Meenie

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


Meenie

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



All times are GMT +1. The time now is 05:37 PM.

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