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?

I think you're actually wanting to display either series name, or category
name. If you just want custom labels on individual data points/columns,
you'll need to manually edit the labels yourself by selecting the value, then
clicking again (aka, a slow double click).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"erawson" wrote:

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?

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?

Thanks

However, I am wanting to chart different concentrations of chemicals in
water. If a certain chemical is not detected I would record ND. I am
wondering how to get the display data labels to display ND and not zero,
without manually entering it into the chart.

Example

Nitrate-Nitrogen Ammonia-Nitrogen TKN Chloride
10 12 5
70
9 ND 6
85
11 2 ND
70

I want the chart to graph it as a zero value, however have the display data
labels correctly showing that it is ND - Not detected



"Luke M" wrote:

I think you're actually wanting to display either series name, or category
name. If you just want custom labels on individual data points/columns,
you'll need to manually edit the labels yourself by selecting the value, then
clicking again (aka, a slow double click).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"erawson" wrote:

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?

The chart labeller add-in take TEXT and numbers; so you can use you data
exactly as is.
Email me a sample file (get address from bottom of my website) and I will
use Bovey labellers to show you the result.
best wishes from a retired chem prof.
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"erawson" wrote in message
...
Thanks

However, I am wanting to chart different concentrations of chemicals in
water. If a certain chemical is not detected I would record ND. I am
wondering how to get the display data labels to display ND and not zero,
without manually entering it into the chart.

Example

Nitrate-Nitrogen Ammonia-Nitrogen TKN Chloride
10 12 5
70
9 ND 6
85
11 2 ND
70

I want the chart to graph it as a zero value, however have the display
data
labels correctly showing that it is ND - Not detected



"Luke M" wrote:

I think you're actually wanting to display either series name, or
category
name. If you just want custom labels on individual data points/columns,
you'll need to manually edit the labels yourself by selecting the value,
then
clicking again (aka, a slow double click).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"erawson" wrote:

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?

Actually I think I figured it out from your link to John Walkenbach's Chart
Tools. Thanks alot though! It was very helpful.

Elizabeth

"Bernard Liengme" wrote:

The chart labeller add-in take TEXT and numbers; so you can use you data
exactly as is.
Email me a sample file (get address from bottom of my website) and I will
use Bovey labellers to show you the result.
best wishes from a retired chem prof.
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"erawson" wrote in message
...
Thanks

However, I am wanting to chart different concentrations of chemicals in
water. If a certain chemical is not detected I would record ND. I am
wondering how to get the display data labels to display ND and not zero,
without manually entering it into the chart.

Example

Nitrate-Nitrogen Ammonia-Nitrogen TKN Chloride
10 12 5
70
9 ND 6
85
11 2 ND
70

I want the chart to graph it as a zero value, however have the display
data
labels correctly showing that it is ND - Not detected



"Luke M" wrote:

I think you're actually wanting to display either series name, or
category
name. If you just want custom labels on individual data points/columns,
you'll need to manually edit the labels yourself by selecting the value,
then
clicking again (aka, a slow double click).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"erawson" wrote:

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?