 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006Chart data label position
I have a 3D column chart that shows the value as a data label. The labels are appearing in the center of each bar. On the Format Data Labels dialog box, no matter what option I select for horizontal & vertical text alignment, the labels aren't moving. I'm using Excel 2003. Does anyone know what is causing this? Thanks, I believe that dialog box refers to text alignment not label alignment. You can select each label individually and move it...click twice with a pause in-between each click to select a label. Or you may want to try the free Excel add-in "Chart Data Labels" You can add linked text from worksheet cells to the labels and position the labels where you want them. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required.  SignatureJim Cone San Francisco, USA "Tanya" <tanyar@greenhosp.org> wrote in message I have a 3D column chart that shows the value as a data label. The labels are appearing in the center of each bar. On the Format Data Labels dialog box, no matter what option I select for horizontal & vertical text alignment, the labels aren't moving. I'm using Excel 2003. Does anyone know what is causing this? Thanks, Jim, thanks for your response. You're right the description does say Text Alignment, but what text is it trying to align if not the data labels? Since it's the Format Data Labels dialog box it seems to me that the label text is what it should align. It also seems to me that it would align the text with the data marker, but maybe I'm wrong about that too. Help doesn't shed much light on this, nor does the MS Knowledge Base. Tanya > I believe that dialog box refers to text alignment not label alignment. > You can select each label individually and move it...click twice with [quoted text clipped - 16 lines] > vertical text alignment, the labels aren't moving. I'm using Excel > 2003. Does anyone know what is causing this? Thanks,
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.