Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Values in Bars (ExcelXP)

    Have an old picture of a chart I once made (lost the sheet...); here there is a (3D) Barchart where I managed to place the values for each bar not at the top (above each bar) but inside each bar itself (at half height)....

    I forgot how I ever did that... anyone with a clue as to how this can be done?

    Erik Jan

    PS. The only one I can think about is creating an invisible extra series with half the height and overlaying that one... that's too much... or is it?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Values in Bars (ExcelXP)

    You can physically move them all

    You can use Rob Bovey's excellent <img src=/S/free.gif border=0 alt=free width=30 height=15> addin: XYChartLabeler to help with this

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Putnam Valley, New York, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Values in Bars (ExcelXP)

    Right-click on the data labels, Format the data labels, click on the Alignment tab and select the LABEL POSITION that you desire (Center, Inside End, etc.)

  4. #4
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Values in Bars (ExcelXP)

    That helped! Thanks!

  5. #5
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Values in Bars (ExcelXP)

    I'm not getting options like (Inside End etc.); the left / right / top / center options seem to align the text in its label-box but not the label-box inside the bar

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Values in Bars (ExcelXP)

    That option does not seem available in the 3d-chart (if you pick the regular column charts it is available in the alignment tab)

    I did notice that if you create a 3d column and pick "Stacked type" they automatically go to the center. If you have only 1 range it will be a good workaround, but if you have more than 1, they will get stacked and that might not be what you want.

    Steve

Posting Permissions

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