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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why can't I see the data labels I just added?
I have a stacked column chart I created last week with three data series. I
added a fourth series today. I have data labels on the original three, and tried adding data labels to the fourth series. Excel acts like I added the labels by giving me a choice to format them, but I can't see them at all. I've tried changing the font color, but they don't show up at all. Three of the four data series are in consecutive columns B-D and the fourth series is in a non-consecutive column F. Does this have anything to do with it? I have Windows XP and Excel 2007 with SP1. What am I doing wrong? |
#2
|
|||
|
|||
Why can't I see the data labels I just added?
Hi Mark.
I have just tried to replicate your problem and have put a file up for you at:- http://www.pierrefondes.com/ It is the item at the top of the home page. I am not seeing any problems. Maybe you could give us some more details so that I or others could assist further? "Mark" wrote: I have a stacked column chart I created last week with three data series. I added a fourth series today. I have data labels on the original three, and tried adding data labels to the fourth series. Excel acts like I added the labels by giving me a choice to format them, but I can't see them at all. I've tried changing the font color, but they don't show up at all. Three of the four data series are in consecutive columns B-D and the fourth series is in a non-consecutive column F. Does this have anything to do with it? I have Windows XP and Excel 2007 with SP1. What am I doing wrong? |
#3
|
|||
|
|||
Why can't I see the data labels I just added?
Hi Mark, I have just put up a second version for you at:-
http://www.pierrefondes.com/ Maybe this is what you want? "Mark" wrote: I have a stacked column chart I created last week with three data series. I added a fourth series today. I have data labels on the original three, and tried adding data labels to the fourth series. Excel acts like I added the labels by giving me a choice to format them, but I can't see them at all. I've tried changing the font color, but they don't show up at all. Three of the four data series are in consecutive columns B-D and the fourth series is in a non-consecutive column F. Does this have anything to do with it? I have Windows XP and Excel 2007 with SP1. What am I doing wrong? |
#4
|
|||
|
|||
Why can't I see the data labels I just added?
Hi,
Thanks, the second file is what I'm trying to do. I am using Excel 2007, but saving the file as Excel 2003 format. I've learned since I first posted that my co-workers using Excel 2003 can see the data labels that I add, but I still can't see them in Excel 2007 and they don't print either. Could you recreate your file, and save it in Excel 2003 format, then later add another data series in column G and stack it on top, and then add data labels to it? That's closer to the process I've done. Thanks for investigating. "trip_to_tokyo" wrote: Hi Mark, I have just put up a second version for you at:- http://www.pierrefondes.com/ Maybe this is what you want? "Mark" wrote: I have a stacked column chart I created last week with three data series. I added a fourth series today. I have data labels on the original three, and tried adding data labels to the fourth series. Excel acts like I added the labels by giving me a choice to format them, but I can't see them at all. I've tried changing the font color, but they don't show up at all. Three of the four data series are in consecutive columns B-D and the fourth series is in a non-consecutive column F. Does this have anything to do with it? I have Windows XP and Excel 2007 with SP1. What am I doing wrong? |
#5
|
|||
|
|||
Why can't I see the data labels I just added?
In 2007 Microsoft introduced a new charting module. In the process it
broke a lot of features, some intentionally, others accidentally. I cannot reproduce your problem with 2007 SP2. Of course, that does not preclude the problem from existing in SP1. On Mon, 5 Oct 2009 16:11:01 -0700, Mark wrote: I have a stacked column chart I created last week with three data series. I added a fourth series today. I have data labels on the original three, and tried adding data labels to the fourth series. Excel acts like I added the labels by giving me a choice to format them, but I can't see them at all. I've tried changing the font color, but they don't show up at all. Three of the four data series are in consecutive columns B-D and the fourth series is in a non-consecutive column F. Does this have anything to do with it? I have Windows XP and Excel 2007 with SP1. What am I doing wrong? Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
#6
|
|||
|
|||
Why can't I see the data labels I just added?
Hi Mark, I have done as requested and uploaded a new file today Fri Oct 9/9.
The file is at the top of the home page. I cannot see any problem. The only thing that I can think of is that I am on Service Pack 3. Maybe you need to upgrade? Please hit Yes if my comments have helped. Thanks! "Mark" wrote: Hi, Thanks, the second file is what I'm trying to do. I am using Excel 2007, but saving the file as Excel 2003 format. I've learned since I first posted that my co-workers using Excel 2003 can see the data labels that I add, but I still can't see them in Excel 2007 and they don't print either. Could you recreate your file, and save it in Excel 2003 format, then later add another data series in column G and stack it on top, and then add data labels to it? That's closer to the process I've done. Thanks for investigating. "trip_to_tokyo" wrote: Hi Mark, I have just put up a second version for you at:- http://www.pierrefondes.com/ Maybe this is what you want? "Mark" wrote: I have a stacked column chart I created last week with three data series. I added a fourth series today. I have data labels on the original three, and tried adding data labels to the fourth series. Excel acts like I added the labels by giving me a choice to format them, but I can't see them at all. I've tried changing the font color, but they don't show up at all. Three of the four data series are in consecutive columns B-D and the fourth series is in a non-consecutive column F. Does this have anything to do with it? I have Windows XP and Excel 2007 with SP1. What am I doing wrong? |
#7
|
|||
|
|||
Why can't I see the data labels I just added?
Hi,
I'm sorry, I don't know your name. And, thanks for updating your file, it looks fine to me so I don't yet know what my issue is. But, now that you've told me that there's an SP3 I'll upgrade. I didn't even know about it. I've also got one of my company's tech support guys coming by this morning to investigate. I'll let you what happens, and thank you again for the help. "trip_to_tokyo" wrote: Hi Mark, I have done as requested and uploaded a new file today Fri Oct 9/9. The file is at the top of the home page. I cannot see any problem. The only thing that I can think of is that I am on Service Pack 3. Maybe you need to upgrade? Please hit Yes if my comments have helped. Thanks! "Mark" wrote: Hi, Thanks, the second file is what I'm trying to do. I am using Excel 2007, but saving the file as Excel 2003 format. I've learned since I first posted that my co-workers using Excel 2003 can see the data labels that I add, but I still can't see them in Excel 2007 and they don't print either. Could you recreate your file, and save it in Excel 2003 format, then later add another data series in column G and stack it on top, and then add data labels to it? That's closer to the process I've done. Thanks for investigating. "trip_to_tokyo" wrote: Hi Mark, I have just put up a second version for you at:- http://www.pierrefondes.com/ Maybe this is what you want? "Mark" wrote: I have a stacked column chart I created last week with three data series. I added a fourth series today. I have data labels on the original three, and tried adding data labels to the fourth series. Excel acts like I added the labels by giving me a choice to format them, but I can't see them at all. I've tried changing the font color, but they don't show up at all. Three of the four data series are in consecutive columns B-D and the fourth series is in a non-consecutive column F. Does this have anything to do with it? I have Windows XP and Excel 2007 with SP1. What am I doing wrong? |
Thread Tools | |
Display Modes | |
|
|