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.
MacBook Pro with Retina display, OS X Mavericks (10.9.5)