Solved

internal margins on chart data labels excel 2010

Posted on 2014-04-24
7
4,612 Views
Last Modified: 2016-09-26
Hi Experts,

The options are greyed out when you select Format data labels / Alignment.  As shown in my image, I would like to move my data labels up so that they are more visible.  They are already vertically aligned to 'top'.  I thought I could adjust the top internal margin, but this option is not accessible in Excel 2010.  

I really don't want to put in text boxes as they skew when I pdf the document (which is requirement for this report).

I cannot find an answer on google, just a lot of complaints about Microsoft disabling the options...is there anything I can do to resolve my issue?

Thanks!
Capture.JPG
0
Comment
Question by:grmcra
7 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 40022031
Hello,

sorry, but here is bad news. Formatting of data labels and some other aspects of chart text labels is either not possible or a real pain. In the case you describe it's not possible. Excel does not have any handles or parameters to manipulate the format of the data labels.

This has been a bone of contention for a lot of people for quite some time. If it is any consolation: You are not alone with your frustration.

But, as it stands right now, there is no solution. What you describe simply cannot be done in Excel 2010 charts.

Don't shoot the messenger.

Cheers, teylyn
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 40022101
Here's a link to a very faint ray of hope and I'm only posting it blind because there  is no direct solution available for regular chart functionality (apologies in advance to the mods).

http://www.get-digital-help.com/2013/03/13/custom-data-labels-in-a-chart/
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 250 total points
ID: 40022220
@regmigrant, the link you posted shows how to change a data label text. That's good to know, but it does not address the problem as posed in the question.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 19

Accepted Solution

by:
regmigrant earned 250 total points
ID: 40022242
My intention was to provide the OP with a possible method of seeing the data he wanted to see, as you already pointed out there is no solution to the question as posed.
Using this technique *might* give a better result than he gets at the moment - on the basis that plotting against a secondary axis will produce different positioning of the labels- but without  a copy of the sheet he is working with I can't guarantee it.

I did say the hope was very faint :) -
0
 

Author Closing Comment

by:grmcra
ID: 40023321
Thanks for answering, at least I won't keep trying to look for a solution : )
0
 
LVL 1

Expert Comment

by:-Polak
ID: 40854761
Just came across this question, this sucks, I'm having tons of scale problems with "Running total in" lines on top of bar charts. I don't want to plot the running total on a secondary axis because I think that's confusing. All I wanna do for the line that is 10x the scale of any of the other bars or running line totals is have it go off the chart and then make the margin something crazy like 4" and bump down the actual value back into the visible scale. Ugh microsoft why!
0
 

Expert Comment

by:Katrina Armstrong
ID: 41816081
I know this is now years out of date but I just found a really easy fix for this!  Stick an extra line of data on the top and bottom with the data label <apostrophe> <space> <space> so that it shows up as blank and then zero for the data.  You then add the extra lines into your data, delete the spurious zeros from the visible chart and hey presto you have a proper width on your top and bottom bars!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now