Data labels in middle of the chart

[hile trotman]

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

[Jon Peltier]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Jon Peltier]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[hile trotman]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[hile trotman]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>