Results 1 to 4 of 4

Thread: Chart Label Positioning

  1. #1

    Chart Label Positioning



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have created a clustered bar chart and want to show all my data labels at the far right hand side of the graph (all in a column). I've manually moved them all but when I refresh the graph data (using powerpivot slicers) the labels all move again.
    Is there a way to fix the labels so they don't move?

    Thanks,

    J

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,208
    Articles
    57
    Blog Entries
    14
    I don't know that I'm totally following this. Is there any way you could mock up a sample that repros the issue? I'd kind of like to see it in play.

    I'm also curious, what versions of Excel and PowerPivot are you running?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Quote Originally Posted by Ken Puls View Post
    I don't know that I'm totally following this. Is there any way you could mock up a sample that repros the issue? I'd kind of like to see it in play.

    I'm also curious, what versions of Excel and PowerPivot are you running?
    Thanks for taking the time to respond to me.

    I've mocked up a sample in the attached (hope it works!). With month "7" selected on the slicer the labels all line up where I put them, however when I change the month it goes all funny.

    I'm using Excel 2010 and Powerpivot 10.50.2500.0

    Thanks,

    J
    Attached Files Attached Files

  4. #4
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    37
    Articles
    0
    The data labels once manually position will still maintain the related movement with the data point.

    You could use code to reposition the data labels or you could add some additional series and put them on the secondary axes.
    Set the data labels to the new series to be inside base, which will be a non moving location.

    Example 1058.xlsx
    Cheers
    Andy

    www.andypope.info

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •