User profile for user: tomest05
tomest05 Author
User level: Level 1
8 points

Creating a Progress Chart with Donut Chart?

In Numbers how can I create a chart that shows progress to 100% or another determined value (1,000 items sold for example)?


Currently it appears Numbers gives every data entry it's own color. Ideally, I'd like to have a donut chart with multiple data entries that shows progress, meaning one color for anything that is complete or a certain value, and another color for anything that is incomplete or another certain value?


For example, tracking progress for a new process table would look like:

Step Status
Input Raw material Complete
Process Raw materialComplete
Output finished productComplete
Package Finished productNot Complete



And so the Donut chart would show a circle 3/4 filled with Green and then 1/4 Red (75% complete, 25% Not Complete).


Thanks for any assistance!


TJ

MacBook Pro, iOS 11.4.1

Posted on Aug 1, 2018 4:42 PM

Reply
Question marked as Top-ranking reply
User profile for user: Wayne Contello
Wayne Contello
User level: Level 7
26,631 points

Posted on Aug 1, 2018 6:49 PM

Name the table you shared in your post "Task List" and create a new table and title it "Summary" like below:

User uploaded file


In the new table (named "Summary") make the first column a header column.


enter the possible status types in column (in this case "Complete" and "Not Complete").


select cell B1, then type (or copy and paste from here) the formula:

=COUNTIF(Task List::B, $A1)


shorthand is:

B1=COUNTIF(Task List::B, $A1)


select cell B1, then hover the cursor of the bottom edge, then drag the yellow fill control down as needed to fill the formula down.


no select column B of the "Summary" table and add the donut chart.


User uploaded file


To change the color of the categories, single click the chart, then single click the segment, then use the chart style formatter to change the color:

User uploaded file

View in context

Similar questions

3 replies
Question marked as Top-ranking reply
User profile for user: Wayne Contello
Wayne Contello
User level: Level 7
26,631 points

Aug 1, 2018 6:49 PM in response to tomest05

Name the table you shared in your post "Task List" and create a new table and title it "Summary" like below:

User uploaded file


In the new table (named "Summary") make the first column a header column.


enter the possible status types in column (in this case "Complete" and "Not Complete").


select cell B1, then type (or copy and paste from here) the formula:

=COUNTIF(Task List::B, $A1)


shorthand is:

B1=COUNTIF(Task List::B, $A1)


select cell B1, then hover the cursor of the bottom edge, then drag the yellow fill control down as needed to fill the formula down.


no select column B of the "Summary" table and add the donut chart.


User uploaded file


To change the color of the categories, single click the chart, then single click the segment, then use the chart style formatter to change the color:

User uploaded file

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Creating a Progress Chart with Donut Chart?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up