Linking table and charts on Pages Document
I'm creating a habit tracker and I'd like to able to track information in a table in Pages Document, and then have that information automatically added to a line chart. This particular idea is for a Run Tracker. So, on the table in Pages, I'll write out my date, distance, speed, and calories burned. Then on the Chart, I'd like to use a formula to capture that information and represent it on graph.
However, in the table, when I select "Edit Chart Data" there is no option for Formulas, and when I try to use the dropdown menu they're greyed out.
The use case is I'm creating a Bullet Journal for myself for 2024 and want to be able to have these tables and charts interactive throughout the year.
Maybe I'm getting too fancy. I've seen it done in Numbers by a colleague who used to work for Apple and he did it over multiple worksheets. But I'm creating this in a Pages document where I have my planner and would like to have it all represented in the same document.
