+ Reply to Thread
Results 1 to 5 of 5

Chart showing change from first column

  1. #1
    Registered User
    Join Date
    03-27-2012
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    46

    Red face Chart showing change from first column

    Hi,
    I admit charting is not my forte. I am trying to create a waterfall chart whereby my first column is a number, all the columns in between represent the changes to that number, and the last column is the new number (so the columns in between show the increases/decreases to the original number by category arriving at the new end number). I would also like the incremental change bars to show the dollar amount and percentage change if possible and would love it if there was a way for the bars to be one color for an increase and another for a decrease. I'd also like the first and last bars to show the dollar amounts (no percentages) and be a different color from the incremental bars. I was given the attached chart formatting from a co-worker, but don't know how to actually manipulate that data into the chart I need. I have an example of the old chart, but it's kind of a mess so I'm hoping I can figure out how to improve it. Appreciate the help!
    Attached Files Attached Files
    Last edited by Jess0121; 01-22-2016 at 01:42 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,462

    Re: Chart showing change from first column

    I had some trouble understanding the template you posted.

    Have you tried creating the chart from scratch using any of the good tutorials on the internet (http://peltiertech.com/excel-waterfa...bridge-charts/ is one example, or put "excel waterfall chart tutorial" into Google)? That might be easier than trying to edit the existing chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-27-2012
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Chart showing change from first column

    Ok - so I've got my waterfall chart created, but am unsure how to add % change as an additional data label. Any ideas?

    For anyone else reading this to solve their own waterfall issue, here is the site I used to create mine: https://www.ablebits.com/office-addi...hart-in-excel/
    Attached Files Attached Files
    Last edited by Jess0121; 01-22-2016 at 01:41 PM.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,462

    Re: Chart showing change from first column

    The easiest way, for those with pre 2013 versions of Excel, is to use Rob Bovey's free XY chart labeler add-in (www.appspro.com under free utilities).

  5. #5
    Registered User
    Join Date
    03-27-2012
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Chart showing change from first column

    Perfect, now I've got everything I need. Thank you for your help, I've added reputation.

+ 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. Excel chart for showing change
    By ritu2851 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-08-2014, 07:26 PM
  2. Column/Bar chart showing NEW data in a different color
    By justinpeeler in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-21-2014, 04:43 AM
  3. My stacked column Bar chart is not showing the right data!
    By JamesR12 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-14-2013, 07:11 AM
  4. Stacked Column Chart showing the Limits
    By rose4emi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 04:15 AM
  5. Chart showing percent change
    By jermsalerms in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-20-2006, 01:00 PM
  6. Bart chart with lines showing % change between elements
    By Tom in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-30-2005, 09:05 PM
  7. Excel chart data labels showing % change instead of value?
    By MFritz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-20-2005, 10:05 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