+ Reply to Thread
Results 1 to 5 of 5

Resize Segment of Stacked Chart to fit Data Labels

  1. #1
    Registered User
    Join Date
    12-16-2014
    Location
    Baltimore, MD
    MS-Off Ver
    2010
    Posts
    3

    Resize Segment of Stacked Chart to fit Data Labels

    Greetings,

    I've inherited a stacked chart with some segments that are very small. Would like to resize those segments so data labels fit. Thanks

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

    Re: Resize Segment of Stacked Chart to fit Data Labels

    The size of the segment in a stack represents the value of the segment in relation to all the other data points. You can't just resize to fit text as this would make the chart meaningless.

    Perhaps you need to move the data label to the side so it is readable. Or only show data labels for values over a certain threshold
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-16-2014
    Location
    Baltimore, MD
    MS-Off Ver
    2010
    Posts
    3

    Re: Resize Segment of Stacked Chart to fit Data Labels

    Thank you. Unfortunately the powers that be want to see a chart with labels on the bars. Is there a way to manipulate the
    table or scale to accomplish this?

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

    Re: Resize Segment of Stacked Chart to fit Data Labels

    No. You would have to change the dimension of the chart and or plot area so there is more space.

  5. #5
    Registered User
    Join Date
    12-16-2014
    Location
    Baltimore, MD
    MS-Off Ver
    2010
    Posts
    3

    Re: Resize Segment of Stacked Chart to fit Data Labels

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Put a data labels in % value in some stacked bar chart in $ value
    By lp_cpa in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-01-2013, 09:04 AM
  2. stacked column chart with data labels
    By broro183 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-21-2009, 08:06 AM
  3. Replies: 1
    Last Post: 09-11-2007, 08:55 AM
  4. How do I get total value data labels in a stacked bar chart?
    By blemerson in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-25-2006, 08:40 PM
  5. Data labels on a stacked chart
    By whouser in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-11-2005, 05:06 PM

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