move values text in graphs all series at once. Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tibuix - 19 Jul 2006 20:26 GMT

Using excel since Office 4.0x, I wonder how come we cannot move all values
text in a bar chart. The programs always put this text at the top of the
bars. Is there a way to move all of them at once? I have tried to do it, but
everytime I try to select them it allow me to move only one label.

Thanks and good luck.

Tibuix

Reply to this Message

Tushar Mehta - 24 Jul 2006 01:33 GMT

Good point. While we wait for MS to consider this for some future release
of Office, you might want to look at the following:

Double-click the labels, then select the Alignment tab. Depending on the
kind of chart you have, you will have some kind of options. For a column
chart they include things like Outside End, Inside End, Center, and Inside
Base.

For even better refinement get Rob Bovey's XY Chartlabeler add-in from
www.appspro.com. It includes a "move data label" capability that moves all
the data labels for a series.

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Using excel since Office 4.0x, I wonder how come we cannot move all values
> text in a bar chart. The programs always put this text at the top of the
[quoted text clipped - 13 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=6ab12392-b7ca-4
5a6-9221-2492977fb461&dg=microsoft.public.excel.charting

Reply to this Message