+ Reply to Thread
Results 1 to 3 of 3

Waterfall : add % on top of data label

  1. #1
    Registered User
    Join Date
    06-21-2019
    Location
    Grenoble
    MS-Off Ver
    Microsoft 365 MSO
    Posts
    4

    Waterfall : add % on top of data label

    Hello everyone

    I have done my waterfall graph, with datalabel (variation in mEUR). On top, for each variation, I need to add variation in %. In the join excel, for A as axample, I have already datalabel "-4,5", I need to add "-17,9%" as information.

    I tried to add a second serie, with the same axis, but it's not working

    I need something automatic as I have several similar graphe to do.

    thanks for your support !
    Attached Files Attached Files
    Last edited by Blondy_R; 06-25-2019 at 05:56 AM. Reason: add attachment excel file

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

    Re: Waterfall : add % on top of data label

    Modification of the new chart types, waterfall/sunburst/treemap etc, is very limited.

    You would need to build the chart in the old way and then you could add extra series to displayed linked data labels.
    See Jon Peltier's site for more information on waterfall charts and how to manually construct them.
    https://peltiertech.com/excel-waterf...bridge-charts/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-21-2019
    Location
    Grenoble
    MS-Off Ver
    Microsoft 365 MSO
    Posts
    4

    Re: Waterfall : add % on top of data label

    ok thanks for the quick replu I will do so. Hope excel will improve automatization in next version !

+ 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. Pivot Chart not displaying data label values for the first Legend label
    By zykkzxxy789077 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2016, 05:46 AM
  2. Follow hyperlink stored in label controltiptext when clicking on userform label
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2015, 08:24 AM
  3. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  4. How to show Negative Data Label Values in Red - Waterfall Chart
    By kirtanpatel85 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-31-2014, 03:35 PM
  5. How to add Data Label to Waterfall chart
    By poweskasebastian in forum Excel General
    Replies: 1
    Last Post: 10-31-2014, 02:10 PM
  6. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  7. Waterfall Chart Data Labels
    By nickFe in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-17-2011, 05:30 AM

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