Use a different range for labels and add them to chart an Excel chart label
add-in

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

Tushar's Hover Chart Label utility:
http://tushar-mehta.com/excel/softwa...bel/index.html

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"erawson" wrote in message
...
I am trying to make a non-number value show up in a column chart. The chart
is automatically showing any non-number value as zero. This is fine,
however
I would like the Display Data Labels to show the value that is displayed
in
the cell.

How do I do this?