iosiworkmacosnumbers
So I have a chart in Numbers (iOS version, but I can use the macOS version, if needed,) which has formula that references some values from the chart, as well as some values from a different chart. I want to autofill this formula, while keeping the references from the other chart the same.
I want A2 to change for each row, A3, A4, etc. But I want values from table 2 to stay referenced to B2.
I tested this in Numbers '09 2.3 (554), and it worked for me without doing anything particularly special: see below. Have I understood correctly?
As far as I know there is no way to make the desired changes all at once, but there is a way that you can make things significantly faster than creating a brand new chart.
As it appears you've already done, copy and paste the chart into your Numbers worksheet. Depending on the chart you've created, select an individual line, bar, pie segment etc. and open the chart pane in the inspector. Here's a screenshot of what that looks like (with "Example 2" being the copied and pasted chart):
As you can see, in the field labeled "Data," Table 1 is referenced. This source can easily be changed to a different table. Just delete the listed source and select the new source of data from your worksheet (you don't have to type in the source). Depending on your chart you may also want to change the data source for the x-axis labels. This is also controlled by the inspector. That can be changed here:
While you'll have to change the data source for each line of the chart, it's certainly faster than creating a whole new chart and having to format it the way you'd like.
Best Answer
Click on the up arrow to the right of the cell reference (at the bottom of your screenshot) for the one you want to fix, then check the Row and Column boxes to fix the reference to both the row and column.