[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
KhaaL
General User

Joined: 26 Nov 2007
Posts: 8

 Posted: Mon Jul 23, 2012 3:12 am    Post subject: [Solved] making simple piechart out of my household expenses I'm tracking expenses in my household with a spreadsheet that has two colums, first one is the category of the transaction, and the latter is the amount of the transaction which is printed both as a positive and negative numbers depending if its me or my partner that's paying. To clarify how it looks, here's an example: gas 75 groceries -50 groceries 25 What I want to do is to have a piechart of my households expenses to categorize each transactions to their respective category and then show up as a piechart, with the categories as labels and with the total amount spent in each of them along with the precentage. so that would be: Gas 75 (50%) and groceries 75 (50%) [insert nice round circle here] This would of course require all the minus signs to be stripped out temporarly, or to find another way to mark the payee of each transaction. Could someone help me out making this a reality?Last edited by KhaaL on Tue Jul 24, 2012 5:09 am; edited 1 time in total
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6732

Posted: Mon Jul 23, 2012 4:32 am    Post subject: Re: making a simple piechart out of my household expenses

 KhaaL wrote: I'm tracking expenses in my household with a spreadsheet that has two colums, first one is the category of the transaction, and the latter is the amount of the transaction which is printed both as a positive and negative numbers depending if its me or my partner that's paying. To clarify how it looks, here's an example: gas 75 groceries -50 groceries 25 What I want to do is to have a piechart of my households expenses to categorize each transactions to their respective category and then show up as a piechart, with the categories as labels and with the total amount spent in each of them along with the precentage. so that would be: Gas 75 (50%) and groceries 75 (50%) [insert nice round circle here] This would of course require all the minus signs to be stripped out temporarly, or to find another way to mark the payee of each transaction. Could someone help me out making this a reality?

why not mark the payee in another column?

 Code: Item   Amt   Who Food   25      Bill Food   50     Jane Gas     75     Jane

Then just use Data > Data Pilot > etc to sum up the results as you want and graph the results from the data pilot table.

This allows much more control over analysis and is a lot easier to maintain.

BTW a pie chart is usuallly about the worst way to display data. If you get more than 3 or 4 expense categories a pie chart is close to useless for really understanding what's happening.

For your data I'd recommend, (in Calc anyway) a vertical bar chart which I think Calc actualy calls a bar chart.
_________________
jrkrideau
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
KhaaL
General User

Joined: 26 Nov 2007
Posts: 8

 Posted: Tue Jul 24, 2012 2:59 am    Post subject: After fiddling with datapilot a bit, i realized that it worked wonders for my needs. Thanks a lot!
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6732

Posted: Tue Jul 24, 2012 5:00 am    Post subject:

 KhaaL wrote: After fiddling with datapilot a bit, i realized that it worked wonders for my needs. Thanks a lot!

It does have its days Would you go to your first post in the thread and edit it (button on top left) by ading "Solved" to the Subject header? Thanks.
_________________
jrkrideau
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum