1

There is a budget for each employee to use on expenses. We keep track of expenses throughout the year as it gets used. At the end of the year, a lot of these budgeted dollars do not get spent and i'd like to highlight this to the employees, while also showing the categories of where the money is being spent. (Categories will be used multiple times throughout the year)

Eg Data Set:

Budget for the year: $10000

Expenses so far:

  • Registration: $400
  • Flight $900
  • Per Diems $200
  • Hotel $400

I'm using a pivot table/graph but can't seem to figure out how to get the remaining balance into it.

Thanks for your help and time to read this!

1 Answer 1

1

Surely making an additional entry for remaining expenses would be the simplest method.

But In your example.

Registration: $400
Flight $900
Per Diems $200
Hotel $400
Remaining = (budget for the year) - (sum of the above expenses)

This would give you the value which you can then work into your pie chart

2
  • I get so into my brain that the simplest answer was right in front of me! thank you
    – meow_katz
    Apr 27, 2016 at 17:30
  • Hehe no problem we've all been there. Glad I could help
    – Tim Mahood
    Apr 27, 2016 at 17:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .