Data labels in middle of the chart
 

Is there a way to move data labels. I have negative and positive values on my
chart and it caused the axis to move up, but so did the labels. and now the
lables are in the middle accross the data points. looks busy.

is there anyway to have the labels display on the bottom of the bar chart
even though the axis is not at the bottom anymore?
--
Hile

Data labels in middle of the chart
 

Double click on the axis, and on the Patterns tab, for Tick Mark Labels,
choose Low.

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


"hile trotman" wrote in message
...
Is there a way to move data labels. I have negative and positive values on
my
chart and it caused the axis to move up, but so did the labels. and now
the
lables are in the middle accross the data points. looks busy.

is there anyway to have the labels display on the bottom of the bar chart
even though the axis is not at the bottom anymore?
--
Hile

Data labels in middle of the chart
 

Thanks so much. I knew I could do it I just couldn't remember where on earth
that was.

You guys rock!
--
Hile


"Jon Peltier" wrote:

Double click on the axis, and on the Patterns tab, for Tick Mark Labels,
choose Low.

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


"hile trotman" wrote in message
...
Is there a way to move data labels. I have negative and positive values on
my
chart and it caused the axis to move up, but so did the labels. and now
the
lables are in the middle accross the data points. looks busy.

is there anyway to have the labels display on the bottom of the bar chart
even though the axis is not at the bottom anymore?
--
Hile