Data labels in middle of the chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hile trotman - 27 Jul 2006 15:39 GMT

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?

Signature

Hile

Reply to this Message

Jon Peltier - 28 Jul 2006 03:09 GMT

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
_______

> Is there a way to move data labels. I have negative and positive values on
> my
[quoted text clipped - 4 lines]
> 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?

Reply to this Message

hile trotman - 28 Jul 2006 16:40 GMT

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

You guys rock!

Signature

Hile

> Double click on the axis, and on the Patterns tab, for Tick Mark Labels,
> choose Low.
[quoted text clipped - 14 lines]
> > 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?

Reply to this Message