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  

Dropping data labels



 
 
Thread Tools Display Modes
  #1  
Old January 25th, 2006, 01:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Dropping data labels

Okay. This is really starting to bug me.

Can anyone help me understand why I can see data lables when I look at the
spreadsheet but not when I look at the spreadsheet in print preview mode?
When I print the sheet out, I seem to lose the data label as well.

Thanks!
-CKD
  #2  
Old January 28th, 2006, 03:33 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Dropping data labels

Could you describe the labels which have gone missing?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Caro-Kann Defence" wrote in
message ...
Okay. This is really starting to bug me.

Can anyone help me understand why I can see data lables when I look at the
spreadsheet but not when I look at the spreadsheet in print preview mode?
When I print the sheet out, I seem to lose the data label as well.

Thanks!
-CKD



  #3  
Old February 1st, 2006, 12:43 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Dropping data labels

Hi Jon.

Sorry for the delayed response. I am trying to set up customized labels by
setting the value of the label to the value in a cell. It seems to be okay so
long as the value is greater than zero. However, less than zero values show
up when I look at the chart in Excel but don't seem to appear when I look at
them in print preview.

Thanks.

"Jon Peltier" wrote:

Could you describe the labels which have gone missing?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Caro-Kann Defence" wrote in
message ...
Okay. This is really starting to bug me.

Can anyone help me understand why I can see data lables when I look at the
spreadsheet but not when I look at the spreadsheet in print preview mode?
When I print the sheet out, I seem to lose the data label as well.

Thanks!
-CKD




  #4  
Old February 1st, 2006, 01:29 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Dropping data labels

Hmmm, there's nothing intrinsically different about a label that displays a
negative number than one that displays a positive number. Are these
datalabels, by the way, or textboxes?

If you have a label that appears in the chart, and change the value in the
linked cell, does the label disappear?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Caro-Kann Defence" wrote in
message ...
Hi Jon.

Sorry for the delayed response. I am trying to set up customized labels by
setting the value of the label to the value in a cell. It seems to be okay
so
long as the value is greater than zero. However, less than zero values
show
up when I look at the chart in Excel but don't seem to appear when I look
at
them in print preview.

Thanks.

"Jon Peltier" wrote:

Could you describe the labels which have gone missing?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Caro-Kann Defence" wrote in
message ...
Okay. This is really starting to bug me.

Can anyone help me understand why I can see data lables when I look at
the
spreadsheet but not when I look at the spreadsheet in print preview
mode?
When I print the sheet out, I seem to lose the data label as well.

Thanks!
-CKD






 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting hover data labels to cells other than source data Darren Charts and Charting 1 January 24th, 2006 10:20 AM
Query does not order the same data in the same way Milković Aleksandar Running & Setting Up Queries 10 December 15th, 2005 12:01 PM
Unable to have multiple queries feeding a single report PZ Straube Setting Up & Running Reports 15 June 15th, 2005 08:16 AM
Sort pages? David General Discussion 15 May 13th, 2005 11:33 PM
Pulling data from 1 sheet to another Dave1155 Worksheet Functions 1 January 12th, 2005 05:55 PM


All times are GMT +1. The time now is 08:34 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.