+ Reply to Thread
Results 1 to 2 of 2

Fixed position for numbers on a stacked column chart.

  1. #1
    Registered User
    Join Date
    06-15-2016
    Location
    BC
    MS-Off Ver
    excel 2013
    Posts
    52

    Fixed position for numbers on a stacked column chart.

    Hello,

    I have a stacked column chart with about 30 bars. Aesthetically the numbers within the chart look better when placed 'on top' of the bars within chart.
    Unfortunately, this is done manually, as the only options within the table are 'center', 'inside end', 'inside base' (all of which looks terrible).
    These bars are simply to show a level of completeness for various things.

    A one time effort to do this manually would be fine, however anytime something is marked as complete, the number moves. This forces me to manually finagle each of the numbers to sit nicely on top of the bar again.

    Is there a way to lock the numbers in place, or adjust correctly so I don't need to move them back to the top of the bar anytime somethings marked as done?

    Thank you in advance for any help.
    Kanuck

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

    Re: Fixed position for numbers on a stacked column chart.

    If you mean you have a single value showing the total of the stack then use another series, plotted as line to display the total data label.
    If not can you post example example of your chart type so we can see exactly what you have.
    Cheers
    Andy
    www.andypope.info

+ 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. Fixed Position Cells or Chart
    By DauntlessDS in forum Excel General
    Replies: 4
    Last Post: 02-08-2015, 03:43 PM
  2. [SOLVED] Convert Chart Creation Macro to Stacked Column Chart
    By JBeaucaire in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-24-2014, 01:08 PM
  3. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  4. Replies: 2
    Last Post: 04-25-2012, 04:53 AM
  5. Need help to set Chart to select data that doesnt have a fixed column position.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2012, 03:11 AM
  6. VBA code to position data labels on top of the stacks in a stacked columns chart
    By NiceLittleRabbit in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-25-2011, 09:32 AM
  7. To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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