My issue with my pie chart is that I can’t seem to stop the chart from reporting a category
with no value. I am using it for a money spending tracker. I have my finances going to different categories. The (Series)
data for the pie chart is a list of spending categories. I.E. Bills, Groceries, Gas, etc… In the (Category) side is the
dollar amount for the above series. I have the series as a “SUMIF” logic. I.E. when I enter a withdraw for a groceries, I
state on my checking register that this withdraw is the category “Groceries” in a specific column. The formula finds the key
word “Groceries” and gets the value from the amount withdrew column on my checking register. It than will add up all
withdraws for the entire month for groceries in one cell.
The problem I am having, is the categories that I
haven’t spend money in. It shows a $0.00 reference on the pie chart. With about 30 categories, there isn’t a lot of room in
the chart for something without a value, and just looks sloppy. If I clear the formula from that specific cell that has a 0
value reporting to the chart, it than removes it from the chart. It than looks as I wanted it, but it won’t be able to update
once I do spend for that category. There is no longer the SUMIF logic. If there is a formula in the cell, it shows it on
the chart. Regardless if it has money withdrew from that category or not.
I tried formatting the cells as ##??.
The categories that don’t have any money spent, show as blank, but it still shows a reference to it on the pie chart.
I hope I made myself clear, and I’m not too confusing. I am out to sea currently and somewhat limited to files that
I can attach. If anyone would need a sample ok the work, I could see if I could set it up.
Sorry for the long