Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default move values text in graphs all series at once. Excel

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/comm...excel.charting
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,071
Default move values text in graphs all series at once. Excel

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

In article ,
says...
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/comm...excel.charting

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sum color filled cells in Excel with no values or text? Oy! Excel Discussion (Misc queries) 2 March 9th 06 06:59 PM
Excel how do I link text values in one sheet to another sheet? chrisjtm Excel Discussion (Misc queries) 3 March 9th 06 07:09 AM
Excel keeps converting text to date format John T via OfficeKB.com Excel Discussion (Misc queries) 4 September 12th 05 06:48 PM
How to assign character (text) values to y-axis in a Excel chart? cy Charts and Charting in Excel 1 July 16th 05 10:39 PM
Excel should not automatically extend series or fill values whisperlm Excel Discussion (Misc queries) 0 July 13th 05 07:06 PM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"