Extending a graph series by one column.
I keep track of my assets in Numbers. I used to use Excel, but switched to Numbers over a year ago and for the most part I am very satisfied.
However, every month or so when I enter a new column of data, I want to update my graphs.
I go to a graph, click on the series being plotted, then I want to add one more column to the series.
For example. Asset Worksheet::Table 1::$FC$48:$FW$48 and I want to increase it by one column to $FX.
I can double-click on the field and have the cursor show up at the end of the series description. (I can't possibly describe the steps required to get to the point where I can do this double click)
To be specific: In my example: $FC$48:$FW$48 the cursor shows up behind the 8.
I have tried clicking behind the W and using the cursor keys. I can backspace over the 8, the 4, the $ and the W and then type in "X$48". But that is not acceptable.
No matter what I try, I cannot put the cursor behind the W, backspace one character and then type in an X. Nope, I have to have the spreadsheet opened to a location that has the right row but isn't even close to the correct column; scroll and scroll and scroll --- and SCROLL -- across the spreadsheet to find the "dot" that defines the last cell in the series; click on it and drag it one more column over.
Well I have a dozen graphs. Each time this takes me about 5 minutes so I've wasted an hour on something that in Excel would have taken 5 minutes total.
How do I just change that one character by typing it in? I can't tell you the number of times trying to drag that selection dot just one cell has lead to all kinds of screw-ups in my graphs.
There hasn't been -ANYTHING- added to Numbers in the last 3 years that I care about.
I've asked this question before and never received an answer.
Is there something I'm just missing?
