How to "lock" a chart reference

Question

Level 1

5 points

How to "lock" a chart reference

I use numbers to track daily activities for my business. Each row is a day and the columns each represent the different activities I track.

I use a pie chart to visualize how my work day is split up between these tasks.

Creating a year-to-date pie-chart was simple... Creating a chart from a footer row totalling each column.

HERE'S MY QUANDRY:

I like seeing a "today" chart as well... Since as each day passes I add a new row to the top of the sheet - I initially tried creating my chart from that first row. However - the following day when I add a new day (row) above the previous day - the pie chart reference stays with the original row I defined it as. I must be missing something... somewhere... (?) - I'd like to tell my pie chart to ALWAYS and ONLY reference the second row of the table. (b2).

I thought I'd be clever by adding another table with a single header (matching my primary logging table) and a single row and in each cell of that row referencing it's counterpart in the main table. Again - the references shift as soon as I add another row.

ARRRGgh!! I mean - yes... I can (and have) simply been redefining the chart references daily as a workaround. Pretty painless on the desktop version. Though on the iOS version - this is a pain. It would be wonderful if there's a way to simply tell that one pie chart to ONLY look at Row 2 for data.

Here's a screen shot: