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

Bug in stacked bar chart in Numbers

In Numbers 3.2.2, when I try to add another row to a stacked-bar chart, the chart can be inconsistent with the original table.

Here is how to reproduce.

1. Fill the top row with years 2000, 2001, and 2002.

2. Fill the second row for "a" with the numbers 10, 20, and 30.

3. Fill the third row for "b" with the numbers 90, 80, and 70. (The sum in each year is 100.)

4. Select the cells (10 20 30) in the second row and create a stacked-bar chart.

5. Click the stacked-bar chart, and click [Edit Data References].

6. Click "90" for 2000, and then shift-click "70" for 2002, to add "b" to the chart.


Problem #1: The cell with "80" for 2001 is not selected as you expect.


7. Click "80" for 2001.


Problem #2: The "70" for 2002 is added to year 2001,

and "80" for 2001 is added to year 2002.

Instead of referencing the years in the top row, it simply adds bars in the order

of the cells clicked.


This is extremely dangerous, because the chart shows something totally different from what is in the table.


User uploaded file

MacBook Pro with Retina display, OS X Mavericks (10.9.5)

Posted on Oct 10, 2015 12:03 AM

Reply
5 replies

Oct 10, 2015 5:21 AM in response to taku

Hi taku,


Thanks for your reply.

You can add a and b both at once in a new stacked bar chart

User uploaded file

Select the Body Cells (data) B2 to D3.

Insert a stacked bar chart in one go.

User uploaded file


Another way (adding a then b)

Select data for a (Cells B2 to D2).

Insert a stacked bar chart.

Click on the chart.

User uploaded file

Click on Edit Data References.

Click on the label b (Cell A3)

User uploaded file


I agree that shift clicking follows the order of clicks to (wrongly) construct the chart. Maybe the Apple engineers did not think of that.


Regards,

Ian.

Bug in stacked bar chart in Numbers

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