+ Reply to Thread
Results 1 to 4 of 4

Graph that's adding values and skipping blanks

  1. #1
    Registered User
    Join Date
    06-04-2017
    Location
    Sweden
    MS-Off Ver
    2010
    Posts
    4

    Question Graph that's adding values and skipping blanks

    Let's say i want to make a graph showing how much i have payed on my car loan.

    I have a table looking something like this that i add my current net worth a few times per month.
    So i get a nice chart about how my economy has been.


    Date In bank atm Paying to car loan
    10 Jan 1000 5000
    12 Jan 980 0
    17 Jan 3500 0
    19 Jan 3400 4500
    25 Jan 3000 0
    5 Feb 2500 500
    10 Feb 2200 3500

    But now i want to have a chart that adds up all payments i made to a loan, so the graph gets higher and higher (and skip the blanks).
    Is that possible, and if so, how?
    Last edited by Ametz; 04-19-2019 at 04:33 PM.

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

    Re: Graph that's adding values

    I would add a helper column that performs the cumulative summation, then use that column in the chart.

    1) The helper column might have a formula like =SUM(C$2:C2) and copy down (note the mix of relative and absolute references for easy copying).
    2) For the chart, select the date column and the helper column -> insert chart -> desired chart type -> desired sub chart type.

    Unless Excel really messes up the chart, that should be close to what you describe.
    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
    06-04-2017
    Location
    Sweden
    MS-Off Ver
    2010
    Posts
    4

    Re: Graph that's adding values

    That helps with the "higher and higher" value.

    But it gets too many of the same value (i have too many rows with data *2 years*)
    So i want the graph to skip blanks or it's useless like this for me.

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

    Re: Graph that's adding values and skipping blanks

    Not sure I understand. If I understand, that should simply require adding an IF() function around the SUM() function with an appropriate "decision logic" =IF(should this cell be blank?,"",SUM(...)). Can I assume that you are already familiar with the IF() function and how to formulate the required logic condition statement?

+ 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. Bar Graph - Adding a table under the graph of the %s
    By KCANBS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-04-2018, 10:18 PM
  2. adding +/- values to points on a graph
    By DNClemens106 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-09-2015, 09:01 AM
  3. [SOLVED] Adding common values in bar graph
    By TylerB2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-21-2014, 12:15 PM
  4. adding data points with different x-axis values to a graph
    By st!ngray in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-19-2012, 09:22 AM
  5. Adding functions and certain X-values to Excel graph
    By V234 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-16-2012, 06:40 PM
  6. Unable to graph the desire x values on line graph..?
    By tigertan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 05:04 AM
  7. Replies: 2
    Last Post: 05-16-2010, 11:23 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