+ Reply to Thread
Results 1 to 4 of 4

money stream chart

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    israel
    MS-Off Ver
    2016
    Posts
    4

    money stream chart

    Hi there

    I have an expenses sheet that I write every expense and incomes I have when I have them(which means that some days I add more than 1 raw to the same day and some days I don't add rows at all) please check the attached file.

    Now, I have created a pivot chart in order to show my money stream visually as the year progresses.
    the problem is that the dates in the charts are not incremented evenly and therefore the graph is not fully true.
    Do you understand what I mean?
    How can I make the dates to spread evenly and to show my money stream through the year with constant spaces between dates so it will be relyably to look at?

    Thanks a lot!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: money stream chart

    If I understand your request correctly, then perhaps the following will help.
    Two columns (F:G) are added to the 'data' sheet
    The 'Date' column is populated with all of the dates between 12/22/18 and today
    The 'Value' column is populated using: =SUMIFS(Table13[value],Table13[date],F155)
    A pivot table and pivot chart are produced using the new columns as source data (modeled on Sheet 1).
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    02-11-2019
    Location
    israel
    MS-Off Ver
    2016
    Posts
    4

    Re: money stream chart

    Thank you! That's exactly what I meant!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: money stream chart

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. Need help calculating up a formula stream
    By newfrito11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2016, 10:48 AM
  2. [SOLVED] Building an IF function stream with and's and or's - Help
    By Aceso in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2013, 02:18 PM
  3. Replies: 0
    Last Post: 11-01-2012, 11:34 AM
  4. How so I import pulse stream?
    By rdoty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2012, 08:53 PM
  5. Money income/expense chart with color indicators for every payment type
    By manu.jarvinen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-04-2009, 08:38 AM
  6. stream read error
    By bembaman in forum Excel General
    Replies: 3
    Last Post: 12-23-2005, 01:00 AM
  7. [SOLVED] Data Stream Converter ??
    By Dan Thompson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2005, 03:06 PM

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