You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to use both actual value and percentage as pie chart label in numbers

I am having some issues trying to format a pie chart as I would like it. What I would like to see is the actual value and the percentage value displayed on the chart itself, with the color labels displaying the name of the category that both values came from. Currently, I have been able to get 2/3 of this to work using information I pieced together from this community, but I have been unable to change the name of the label next to the colors so that it represents the name of the category the variables came from. Below is an image of what I currently have, since uploading images directly wasn't working at the time of posting.


https://ibb.co/fSjXcKB


To clarify, I am happy with what the pie chart itself shows, I would just like to change the numbers next to the color dots above the pie chart to say "category 1", "category 2", etc without changing anything on the pie chart.


MacBook Pro 13", 10.14

Posted on Feb 12, 2020 9:26 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 13, 2020 6:36 PM

Hi Liam,


I was working on this last night (and ran into the 'you can't post' glitch in this and other communities),


Today all was well—whether that was due to the glitch having disappeared or a result of following Apple Support's advice to clear the caches, I don't know.


I got to pretty much the same conclusion as Yellowbox, but chose a slightly different display, using the settings shown for the wedges:

:

There are a couple of issues with attempting the exact display you want.

  • Numbers provides only two type of content for the wedges—Names, and Values
  • While you can include more than one 'name' on each wedge, you can only have one Value.
  • That Value can be expressed in only one format on the chart.
  • Values for the pie chart are contained in a single column of 'body' cells.
  • The chart can also pick up Labels (Names). These Labels must be in cells that are in Header rows or Header columns.


For the example above, the Values are in column C.

On the chart's wedges, those values are expressed as percentages of the full set of numeical values, and are displayed as such.


There are the Header columns, one containing the Category Names, the other a copy of the Value in column C, which, due to being in a Header column, can be used as a Label both on the wedges and in the chart's Legend.


Numbers automatically grabs all of the labels when asked to display Data Point Names, so you can't* use only the Category name on the Legend and both Category name and Amount as a label, or only the Amount label (and Amount value as percent) on the chart.


*can't?

Well, there is at least one workaround.


1: Make the chart as shown, then…

  • Move the Legend box horizontally away from the pie graph to provide some working room.
  • Insert a square shape onto the page.
  • Replace the shape's fill colour with light grey, and set Borders and Shadow both to none.
  • Reduce the height of the shape to the size needed to cover the numbers, but not the name in the bottom entry of the Legend.
  • Duplicate the shape three times and adjust the width of the four rectangles to just cover the numbers at the ends of the labels
  • With the shapes in place over the numbers, move the legend (horizontally) away from the shapes.
  • Select all four shapes without moving them. Reset the Fill colour to white, then go Arrange > Group to group the shapes into a single object.
  • Move the selected shapes object horizontally toward the chart, until you see the right edge of one of the rectangles appear in front of the chart. move the shape left until it is no longer hiding part of the pie.
  • Now move the Legend rightward until it slides behind the grouped shapes and the shapes mask the numbers.


Final result should look like this:


Note: If you take care to use the arrow keys to move the items left and right, but avoid moving the Legend up or down once you've begun to size and place the masks, you'll find it easier to keep them aligned when you are putting them back together and into place.


Pressing the shift key when using the arrow keys will make each 'step' bigger and speed up the move.


Regards,

Barry

8 replies
Question marked as Top-ranking reply

Feb 13, 2020 6:36 PM in response to Yellowbox

Hi Liam,


I was working on this last night (and ran into the 'you can't post' glitch in this and other communities),


Today all was well—whether that was due to the glitch having disappeared or a result of following Apple Support's advice to clear the caches, I don't know.


I got to pretty much the same conclusion as Yellowbox, but chose a slightly different display, using the settings shown for the wedges:

:

There are a couple of issues with attempting the exact display you want.

  • Numbers provides only two type of content for the wedges—Names, and Values
  • While you can include more than one 'name' on each wedge, you can only have one Value.
  • That Value can be expressed in only one format on the chart.
  • Values for the pie chart are contained in a single column of 'body' cells.
  • The chart can also pick up Labels (Names). These Labels must be in cells that are in Header rows or Header columns.


For the example above, the Values are in column C.

On the chart's wedges, those values are expressed as percentages of the full set of numeical values, and are displayed as such.


There are the Header columns, one containing the Category Names, the other a copy of the Value in column C, which, due to being in a Header column, can be used as a Label both on the wedges and in the chart's Legend.


Numbers automatically grabs all of the labels when asked to display Data Point Names, so you can't* use only the Category name on the Legend and both Category name and Amount as a label, or only the Amount label (and Amount value as percent) on the chart.


*can't?

Well, there is at least one workaround.


1: Make the chart as shown, then…

  • Move the Legend box horizontally away from the pie graph to provide some working room.
  • Insert a square shape onto the page.
  • Replace the shape's fill colour with light grey, and set Borders and Shadow both to none.
  • Reduce the height of the shape to the size needed to cover the numbers, but not the name in the bottom entry of the Legend.
  • Duplicate the shape three times and adjust the width of the four rectangles to just cover the numbers at the ends of the labels
  • With the shapes in place over the numbers, move the legend (horizontally) away from the shapes.
  • Select all four shapes without moving them. Reset the Fill colour to white, then go Arrange > Group to group the shapes into a single object.
  • Move the selected shapes object horizontally toward the chart, until you see the right edge of one of the rectangles appear in front of the chart. move the shape left until it is no longer hiding part of the pie.
  • Now move the Legend rightward until it slides behind the grouped shapes and the shapes mask the numbers.


Final result should look like this:


Note: If you take care to use the arrow keys to move the items left and right, but avoid moving the Legend up or down once you've begun to size and place the masks, you'll find it easier to keep them aligned when you are putting them back together and into place.


Pressing the shift key when using the arrow keys will make each 'step' bigger and speed up the move.


Regards,

Barry

How to use both actual value and percentage as pie chart label in numbers

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