+ Reply to Thread
Results 1 to 2 of 2

How to add Data Label to Waterfall chart

  1. #1
    Registered User
    Join Date
    12-14-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2013
    Posts
    2

    How to add Data Label to Waterfall chart

    Hi,

    I am trying to find a way where I can add data labels on top of the waterfall stack automatically as I need my template to be flexible.

    Is there a way to do this without lengthy macros?

    Thanks in advance!
    Sebastian

  2. #2
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: How to add Data Label to Waterfall chart

    You could add a series to the chart, where the categories are the same as for the rest of the data, and the Y values equal the top of the stack. Format this added series using the line chart type, and with no markers and no lines, so it is not visible. Add data labels to this added series, position the labels above the points. Here are options for what's in the labels:

    1. Manually edit the text of the labels.
    2. Select each label (two single clicks, one selects the series of labels, the second selects the individual label). Don't click so much as the cursor starts blinking in the label. Click in the formula bar, type an = sign, then click on the cell that contains the label.
    3. Install Rob Bovey's free Chart Labeler (download it from http://appspro.com) and use it to assign cell text to the labels.
    4. If you're using Excel 2013, use the Labels from Cells option and select the cells that contain the labels.
    Jon Peltier
    http://PeltierTech.com/

+ 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. 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
  2. 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
  3. Waterfall Chart Data Labels
    By nickFe in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-17-2011, 05:30 AM
  4. Waterfall chart
    By wjviveen in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-25-2009, 10:18 AM
  5. [SOLVED] waterfall chart ... once again ...
    By SIGE in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 04-30-2005, 11:06 PM

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