software

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

Could you describe the labels which have gone missing?

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

quot;Caro-Kann Defencequot; gt; wrote in
message ...
gt; Okay. This is really starting to bug me.
gt;
gt; Can anyone help me understand why I can see data lables when I look at the
gt; spreadsheet but not when I look at the spreadsheet in print preview mode?
gt; When I print the sheet out, I seem to lose the data label as well.
gt;
gt; Thanks!
gt; -CKD
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.

quot;Jon Peltierquot; wrote:

gt; Could you describe the labels which have gone missing?
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Caro-Kann Defencequot; gt; wrote in
gt; message ...
gt; gt; Okay. This is really starting to bug me.
gt; gt;
gt; gt; Can anyone help me understand why I can see data lables when I look at the
gt; gt; spreadsheet but not when I look at the spreadsheet in print preview mode?
gt; gt; When I print the sheet out, I seem to lose the data label as well.
gt; gt;
gt; gt; Thanks!
gt; gt; -CKD
gt;
gt;
gt;

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
PeltierTech.com/
_______quot;Caro-Kann Defencequot; gt; wrote in
message ...
gt; Hi Jon.
gt;
gt; Sorry for the delayed response. I am trying to set up customized labels by
gt; setting the value of the label to the value in a cell. It seems to be okay
gt; so
gt; long as the value is greater than zero. However, less than zero values
gt; show
gt; up when I look at the chart in Excel but don't seem to appear when I look
gt; at
gt; them in print preview.
gt;
gt; Thanks.
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Could you describe the labels which have gone missing?
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;Caro-Kann Defencequot; gt; wrote in
gt;gt; message ...
gt;gt; gt; Okay. This is really starting to bug me.
gt;gt; gt;
gt;gt; gt; Can anyone help me understand why I can see data lables when I look at
gt;gt; gt; the
gt;gt; gt; spreadsheet but not when I look at the spreadsheet in print preview
gt;gt; gt; mode?
gt;gt; gt; When I print the sheet out, I seem to lose the data label as well.
gt;gt; gt;
gt;gt; gt; Thanks!
gt;gt; gt; -CKD
gt;gt;
gt;gt;
gt;gt;