MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Show Total Of Money Not Percentages In a Numbers Pie Chart?

I have a budget spreadsheet, and have created a pie chart from the ‘category’ and ‘totals’ (£) columns.

I wanted the chart to show me the total amount spent on Utility Bills, Insurance, etc., per month but instead it is showing me the percentage spent in each type of bill.

I know that totals are possible because Apple shows this in a pie chart in one of their own budget templates.

I have Google-searched for the solution, to no avail.

Your help will be greatly appreciated.

Many thanks in advance.

—–
Mary Frantzoulou

Comments: 4 Responses to “How Do I Show Total Of Money Not Percentages In a Numbers Pie Chart?”

    10 months ago

    You mean you want the actual value, not the percentages? Just go to the Format sidebar on the right (click Format at the top right). Then select the whole Pie Chart. The Format sidebar will show Chart, Wedges, Arrange. Click Wedges. Then under Value Data Format, change it from Percentage to Same As Source Data, or perhaps Number.

    Mary Frantzoulou
    10 months ago

    Sorry, I forgot to mention that I am using Numbers for iOS (iPad) and not on the Mac.

    10 months ago

    Mary: the same option is available on the iPad. Select th pie chart, tap the paint brush button, look through the options for number format.

    Mary Frantzoulou
    10 months ago

    Fantastic, that worked a treat. Thank you. 👍🏼

Comments Closed.