+ Reply to Thread
Results 1 to 4 of 4

Waterfall Chart Data Labels

  1. #1
    Registered User
    Join Date
    02-07-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    16

    Waterfall Chart Data Labels

    Hi All,
    I have modified a friend's waterfall chart so that it can basically be used with any data positive or negative.
    The main problem im having is data labels - I want them in the middle of the bars.
    If I change the data, especially when it crosses the 0 line, my data labels all require manual manipulation.
    Can anyone think of a good way to have the data labels centred in the bars?
    I have attached a spreadsheet to have a play with.
    Many thanks,
    Nick
    Attached Files Attached Files

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

    Re: Waterfall Chart Data Labels

    You can added a series plotted as line which is positioned in the center spot.
    If you move to the secondary axis and use another set of category labels you can get the data labels to display the correct value.

    BTW I think you need to check the results of your chart.
    New Buisness has a value of zero but your chart displays -140.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-07-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Waterfall Chart Data Labels

    Quote Originally Posted by Andy Pope View Post
    You can added a series plotted as line which is positioned in the center spot.
    If you move to the secondary axis and use another set of category labels you can get the data labels to display the correct value.

    BTW I think you need to check the results of your chart.
    New Buisness has a value of zero but your chart displays -140.
    Andy Pope, thank you very much for your help, this is great.
    Where do you live I want to buy you some beer!

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

    Re: Waterfall Chart Data Labels

    I'm in the UK so I guess the beer will have to be virtual

+ 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