+ Reply to Thread
Results 1 to 5 of 5

2 data labels on a Waterfall Chart

  1. #1
    Registered User
    Join Date
    08-23-2021
    Location
    South Africa
    MS-Off Ver
    10
    Posts
    1

    2 data labels on a Waterfall Chart

    Hi, is it possible to have 2 sets of data labels on a Waterfall Chart?
    Or perhaps a legend below with another Data set (like in my picture)?
    Attached Images Attached Images

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

    Re: 2 data labels on a Waterfall Chart

    If you are using the builtin waterfall chart then you have little control over it, as it will not display a dummy series.

    You can however add that value to the category labels.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-10-2021
    Location
    Berlin
    MS-Off Ver
    Office 365
    Posts
    4

    Re: 2 data labels on a Waterfall Chart

    Hello

    I do have quite a similar question.

    I have a waterfall, but to analyze the data correclty I would always need to see the percentages as well (and how they changed vs the previous period). In best case like an additional line.
    But I am open for other solutions as well.

    Attached you find my data (I added my desired line in red).

    Do you have an idea how to solve this?

    Thank you
    Attached Images Attached Images

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    Re: 2 data labels on a Waterfall Chart

    Quote Originally Posted by ByTheSea View Post
    I do have quite a similar question.

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however while you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  5. #5
    Registered User
    Join Date
    09-10-2021
    Location
    Berlin
    MS-Off Ver
    Office 365
    Posts
    4

    Thumbs up Re: 2 data labels on a Waterfall Chart

    Got it. I will open a new thread. Thanks

+ 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. Changing the alignment of Waterfall Chart text labels to vertical
    By keiran110 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-06-2020, 04:25 AM
  2. [SOLVED] Waterfall Chart
    By wiewie002 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-15-2016, 11:30 AM
  3. Replies: 3
    Last Post: 05-05-2015, 02:07 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. Waterfall Chart - Adding text to chart from table
    By smudgepost in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2014, 08:03 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