+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 stacked bar chart: Color coding data labels

  1. #1
    Registered User
    Join Date
    03-24-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    1

    Excel 2010 stacked bar chart: Color coding data labels

    Hello,

    I have a gantt chart which has been built using a stacked bar chart in Excel 2010. What I want is that the labels for the data series (which is the task itself) should be color coded to match the color of the team performing the task (sample chart attached)Attachment 225431. There is a sample excel chart available but that relies on the option of moving the data labels to "Outside: End". For a stacked bar chart, that option is not available.

    Any help would be highly appreciated.

    Thanks.

    Excel gantt chart - example.xlsm
    Last edited by kashifmehmood; 04-03-2013 at 12:48 PM.

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

    Re: Excel 2010 stacked bar chart: Color coding data labels

    Add series to secondary axis and display data labels on extra series,
    I have done Team 1 already
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Excel 2010 stacked bar chart: Color coding data labels

    Hi
    if you remove the axis labels from your vertical axis and move the axis right to accommodate new labels, this macro will:
    1) insert data labels for each visible series (not the white one you're using to set the "start" time"),
    2) change the label colour to the same colours as that series' fill, and
    3) move the data labels to the left of the chart (12 points from the left in this example, you may want to change that).

    The Yellow looks very pale - you may like to try a darker colour.

    Please Login or Register  to view this content.

+ 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