+ Reply to Thread
Results 1 to 3 of 3

Data labels are "behind" shape that is part of the chart. How do I "bring them to front"?

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Data labels are "behind" shape that is part of the chart. How do I "bring them to front"?

    I have a chart (see attached pic) that has a shape (arc) created to be part of the chart so when I copy the chart, the shape comes with it. I can make the arc change size to align with my 2 "core" parts. The problem starts in that, small pieces of the pie have the leader lines, so the white font does not show up against the background. I fixed this, so that any label outside the limit I give will be given a black font.

    All that is fine. The problem is that, for some reason, the labels show up "behind" the chart shape. I don't see any attribute regarding moving labels back/front.

    The shapes can be moved front/back, but it has no effect on labels.

    I even tried doing it via VBA by:

    ActiveChart.Shapes("Block Arc 7").Select
    Selection.ShapeRange.ZOrder msoSendToBack

    Which can work on shapes that are part of the sheet, but not part of a chart. (The above code was "ActiveSheet.Shapes..." that I changed to "ActiveChart.Shapes...", which is how to access the embedded shapes. The code runs, ok, but also does not do anything in terms of seeing it vs. the labels.

    Do the labels have some attribute I could get at? This seems rather odd.

    Thanks!

    label_problem.jpg

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,934

    Re: Data labels are "behind" shape that is part of the chart. How do I "bring them to fro

    The shapes are on a different layer to chart elements and will always be on top.

    You could try using a combination chart to draw the arc.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-19-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Data labels are "behind" shape that is part of the chart. How do I "bring them to fro

    Ok, I managed a work-around.

    I made the shape be a sheet shape rather than a chart shape (if that's the right terminology - which it probably isn't - lol).

    I can then make that be a layer below the chart. Then I grouped the chart and the shape, and it acts the way it should.

    Thanks for the input, Andy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1