I would like to make a pie chart due what it is not made to do
I am building a system for people to track expenses so I have a table called expenses that looks a bit like this:
ID
Location
Month_Year
Power
Water
Sewer
Rent
Office_Supplies
I would like to build a pie chart so the manager can see for a given month (or a range of months) where the money is going. My problem is finding a way to build an the SQL in a way that I can trick the chart into using the Field names as label field and their contents and the number field. Thanks