move values text in graphs all series at once. Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...92977fb461&dg=microsoft.public.excel.charting
 
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.

--
Regards,

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