I have a budget table and types of bills categorised e.g. insurance, utilities, etc. When I create my pie chart it does not consolidate the types of bills; so that instead of adding say two insurance totals under the insurance legend, it has two insurance legends with two totals.
—–
Mary Frantzoulou
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Stop Duplicate Legends In My Pie Chart In Numbers for iOS?
Comments: One Response to “How Do I Stop Duplicate Legends In My Pie Chart In Numbers for iOS?”
Comments Closed.
So it sounds like you have a table with a record on each row. If you make a Pie Chart of that, then you get a pie slice for each record. But it sounds like what you want to do first is to compile a new table with one row per category, and then create a pie chart from that second table.
I have a video on how to use the SUMIF function to create such a table. Using the Numbers SUMIF Function. The video is for macOS Numbers, but it works the same way in iOS.