Apple Intelligence is now available on iPhone, iPad, and Mac!

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

Numbers chart reference column not updating

I have several tables and charts that I use to track stock market performance using the STOCK and STOCKH functions. Every day or so I add new rows to the table, and the chart updates as expected, but with one issue. The X-axis labels for the new rows don’t update, because the Reference column doesn’t update. If I delete and add a data column the Reference column corrects itself. Has anyone run into this?

iPhone XR, iOS 14

Posted on May 9, 2021 8:44 PM

Reply
Question marked as Top-ranking reply

Posted on May 18, 2021 5:55 PM

Evidently new table rows added to the end of the range don’t get automatically added to the chart, at least not consistently. A work-around may be to add a dummy row to the end of the table and include it in the chart. Now when you add real rows, they should get included in the chart because it’s in the range of the chart…

Similar questions

1 reply
Question marked as Top-ranking reply

May 18, 2021 5:55 PM in response to CXV78

Evidently new table rows added to the end of the range don’t get automatically added to the chart, at least not consistently. A work-around may be to add a dummy row to the end of the table and include it in the chart. Now when you add real rows, they should get included in the chart because it’s in the range of the chart…

Numbers chart reference column not updating

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