Trouble Creating a Chart with Correct labels and values

I have a two-column table with the first column being labels and the second being currency values. I select the rows I wish to chart and select Insert - 2D pie chart. The result is a pie chart with percentages and no labels. I tried to change the value type to currency and I got some bogus values that do not reflect what is in the table. How do I get numbers to produce a pie chart with the labels and values I selected?

iMac 21.5″ 4K, macOS 13.0

Posted on Oct 8, 2023 9:37 AM

Reply

Similar questions

4 replies

Oct 10, 2023 9:18 AM in response to Urrrg

I get exactly your chart with the same values if I don't select any data before creating the chart. It's the default data-less chart.


What you have to do is select the data first like in the examples below so it's enclosed by a rectangle with circles at opposite ends, or the whole rows, or the whole table (better not to have empty rows like I have), keep it selected then select the type of chart from the toolbar.




Oct 8, 2023 12:48 PM in response to Urrrg

To get labels on the chart it helps that they are in a header column, which you set in the Table section of the Format sidebar.


Since it's a pie chart it's natural to show values as percentages. You can change their formatting one per one or all at once. To change them all at once select the chart as a whole. Visit the Wedges section of the Format sidebar and try the options. See below I changed the format of the A and B wedges. I also selected Data Point Names.


You can also put an arbitrary name on a wedge. Type it enclosed with quotes in the Name field shown below.




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.

Trouble Creating a Chart with Correct labels and values

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