troubleshooting Question

How do you graph a month by month comparison

Avatar of upobDaPlaya
upobDaPlaya asked on
Microsoft Excel
4 Comments1 Solution401 ViewsLast Modified:
1-I want to be able to display individual graphs for each expense category (a total of 11 graphs) on the items below (home, daily living,Transport, etc.).  For each of the individual graphs/categories I want to show a month by month comparison.  Thus, for the graph "Transportation" I want to see 1 graph that shows each month expenditures as side by side columns...

2-I also want to be able to display my budgeted vs actual and remaining expenses for each category.  However, I cant figure out how to integrate my projected amount within this spreadsheet..Any suggestions on how to integrate projected amounts within this spreadsheet..I really like this spreadsheet for tracking my expenses/income, but am struggling on how to integrate my projected vs actual expenses..

Attached is the spreadsheet...
Personal-budget-Excel.xlsx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros