+ Reply to Thread
Results 1 to 4 of 4

How to set zOrder for datalabels in Chart?

  1. #1
    Registered User
    Join Date
    06-05-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    2

    Smile How to set zOrder for datalabels in Chart?

    Hi,

    I would like to set datalabel order as 'bringtoFront'. Is there anyway to set? Because I have more data labels which should be aligned over and above by half of the data label

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

    Re: How to set zOrder for datalabels in Chart?

    The zorder determined by plot order of series. But this is only reflected in the chart once the file is saved and reopened.
    All labels within a series will have the same z-order.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-05-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How to set zOrder for datalabels in Chart?

    Thanks for reply. Still its not happening . I herewith attachdLabelposition.pnged image for the same.

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

    Re: How to set zOrder for datalabels in Chart?

    An image is usless. I can not tell anything about your chart and it's setup from a picture.

    If you want more help post a workbook example and explain what you expect. Bearing in mind the amount of space required to show those labels and the size of the labels.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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