To further illustrate Brian's points, try this:
Right-click on the sheet tab SPH; from the context menu, choose Rename
Sheet...
In the dialog, type Single Point Hats or whatever other name suits you. Click
OK.
Now check your data ranges again. You'll find that instead of SPH or $SPH,
it will
At 20:19 23/11/2014 -0800, Fred Conly wrote:
I used your second suggestion [adjusting the data ranges to include
column headers] and I could produce labels for two of the three
columns. Strangely, I could not produce the third and I can't figure out why.
Do you mean that you couldn't adjust
Brian:
Thanks for trying to help. Tell me, what does
$SPH or SSPH, it's hard to distinguish which, that
appears before a Data Range and what does it do?
Fred
On 11/24/14 4:33 AM, Brian Barker wrote:
At 20:19 23/11/2014 -0800, Fred Conly wrote:
I used your second suggestion [adjusting
At 13:25 24/11/2014 -0800, Fred Conly wrote:
Tell me, what does $SPH or SSPH, it's hard to distinguish which,
that appears before a Data Range and what does it do?
The SPH will be the sheet name and qualifies the call range to
indicate which sheet in the spreadsheet is being referred to. The
Brian:
Thanks again. The name SPH must be assigned by OO Calc
because it's nothing I named. Also SPH. preceeds each Data Range
from Column A, which contains the x-axis data, and columns C, D,
and E which contain the data charted. The prolific use of $ is
unnecessary and confusing in this
At 16:07 24/11/2014 -0800, FC wrote:
The name SPH must be assigned by OO Calc because it's nothing I named.
Hardly likely: it's the name you (or someone) gave to the sheet -
shown on the tab at its bottom left. The default names are Sheet1,
Sheet2, and so on.
Also SPH. precedes each Data
Brian:
Thanks again.
Why anyone would use the designation SPH to refer to
Sheet n is incomprehensible; why not, for example, SHn?
I understand what you say about multiple sheet references.
In this case there is only one sheet of Data and one sheet of
Chart.
Fred
On 11/24/14 5:13
At 18:40 24/11/2014 -0800, Fred Conly wrote:
Why anyone would use the designation SPH to refer to Sheet n is
incomprehensible; ...
No doubt it stands for something to do with the spreadsheet's
purpose. Ask the author. Oh, look: that's you.
... why not, for example, SHn?
As I mentioned,
I use OpenOffice 3.4.1 with Windows 7 Home Premium 64-bit.
I'm only an occasional chart maker. I created a chart years ago,
of Column, Stacked, with three Data Sets.
Will some kind person please remind me how to change the text
in the Legend for the three Data Sets?
Fred
Hi Fred,
you usually just need to change the title of the colums within the
source data set. If you create a chart within AOO then the chart is an
OLE (object linking and embedding) object. Such objects share a
connection to the source data within the document where you create the
chart. In
Joost:
Thanks. I'm using Open Office Calc. There are three Columns of
Data I used
for the Chart. I must have started the Data Range /below /the Column
Headings.
Hence the three Labels appearing in the Legend, each preceeded by a Square
object with the same color or shading in the Column
At 10:36 23/11/2014 -0800, Fred Conly wrote:
I use OpenOffice 3.4.1 with Windows 7 Home Premium 64-bit. I'm only
an occasional chart maker. I created a chart years ago, of Column,
Stacked, with three Data Sets. Will some kind person please remind
me how to change the text in the Legend for the
Brian:
Thanks. I used your second suggestion and I could produce
labels for two of the three columns. Strangely, I could not
produce the third and I can't figure out why.
Fred
On 11/23/14 5:05 PM, Brian Barker wrote:
At 10:36 23/11/2014 -0800, Fred Conly wrote:
I use OpenOffice 3.4.1
13 matches
Mail list logo