+ Reply to Thread
Results 1 to 3 of 3

Money income/expense chart with color indicators for every payment type

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    Finland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Money income/expense chart with color indicators for every payment type

    Hello

    I'm new to this forum

    I would like to make a chart in Excel 2007 that looks like the image mockup in the attachment. It did work very awkwardly for me so I would like to hear some advice how to make this properly.

    So, the point is to have information copied from my online bank account statement and to "tag" each income/expense with a colored text. Only the payments with same color "tags" should be seen in the chart with the according color. By looking at the attached image you surely know what I mean.

    Do you think this is possible?

    Or if you happen to know different kinds of Excel solutions for this kind of problem?

    Thank you very much.

    (I tried to do the search for this problem but didn't get anything relevant back)
    Attached Images Attached Images
    Last edited by manu.jarvinen; 06-04-2009 at 08:40 AM.

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

    Re: Money income/expense chart with color indicators for every payment type

    The chart will not summarize you data.

    Either use a Pivot table/chart or formula to create series summaries.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-03-2009
    Location
    Finland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Money income/expense chart with color indicators for every payment type

    Wow, thank you very much.
    Pivot chart definitely was the keyword here. I can't believe I didn't realize that.

    For the guys who are total newbies with the pivot tables, there is a very helpful video tutorial about them in Youtube:
    http://www.youtube.com/watch?v=962r5nH7CHw
    Last edited by manu.jarvinen; 06-04-2009 at 08:41 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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