Thread: 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)

The chart will not summarize you data.

Either use a Pivot table/chart or formula to create series summaries.

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