ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Dropping data labels (https://www.excelbanter.com/charts-charting-excel/67370-dropping-data-labels.html)

Caro-Kann Defence

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

Jon Peltier

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




Caro-Kann Defence

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





Jon Peltier

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








All times are GMT +1. The time now is 10:11 PM.

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