Noob Q: char string in Range for Name?

[NewHorizon]

I imagine this must've been discussed before, but I couldn't find it...

With Calc, I open a spreadsheet chart that I was maintaining in Excel.
In Excel, one of the range names was: ="Grand Total". But this disappears in Calc.

In Calc's "Data Ranges" pop-up window, this Range for Name is blank(!), and in the "Data Series" list, instead of "Grand Total", we see "Row 6" - which, of course, is what's then presented in the legend of the chart.

I suppose I could place the words "Grand Total" in a cell and then refer to that cell in the "Range for Name".
But isn't there some way to just enter your own static char string as a "Range for Name"?

[UmTheMuse]

If your question is whether or not it's possible to name a data range, the answer is "yes". I guess it must not be something that translates well between the two programs, but I've used data ranges before and they work fine.

When you're in the pop-up window, you have to press Add (after entering the name) to add the data range. I used to just press OK, but that doesn't add the range.