Ahoy all:
My apologies if this turns out to be a redundancy, but I originally
submitted it some 4 hours ago and it hasn't shown up yet.
Some 20 years ago, I frequently received questions such as those I pose
below, and was able to easily answer them for others.
By now, I seem to have aged out, and am flummoxed by difficulties that
should be rudimentary.
So, should any reader deign to attack my elementary problems, please
keep it simple (& simpleminded) so that I have a chance of understanding.
I am using 4.4.7.2, under Windows (or, as we call it, /Curtains/) 7,
because it seems more than adequate for my purposes, and I am somewhat
dismayed by the number of regressions noted for later versions in the
comments here.
Calc chart legends. What could be simpler, yet more impossible? I have
cracked this at sometime in the past, as I have just one spreadsheet
with my own chart legend text in my choice of fonts, but can see no way
of regaining that control for other charts in my armamentarium.
If I right-click a chart, I am presented with 15 options. One is marked
“Text”, which seems promising, but apparently deals with *positioning*,
not content. The thing which it definitely lacks is any ability to
control the legend text contents, or font.
If I double left-click and then right-click, I now have 9 options,
including one which will delete a legend, (leaving me unsure of what
happens if the chart has more than one legend). But, in any case, no
control, beyond excision, over the legend text or its font.
When I double left-click, I get an interesting collection of
mostly-graphic symbols at the bottom of my screen, where the “Find” box
normally lives. One of these is a capital T in a dotted-line box, which,
when hovered-over, reads: “Text Box”. Sounds promising, but what does it
do, and how does one invoke whatever its action may be?
None of these symbols can be dragged onto the chart, and clicking them –
single or double, left or right – produces no obvious result of any
kind. They have interesting titles, and, if they did anything, might be
quite useful.
My first question, then, is: /how do I gain control over chart legend
text & font?/ And a subsidiary wonderment: /why is it so hard to find
this answer?/
Further routes to failure on this question:
From the on-line manual:
https://help.libreoffice.org/6.1/en-US/text/shared/guide/chart_legend.html?DbPAR=SHARED
<https://help.libreoffice.org/6.1/en-US/text/shared/guide/chart_legend.html?DbPAR=SHARED>
we have, (appreciating that this is targeted at 6.1; probably an
irrelevant distinction):
Editing Chart Legends
To edit a chart legend:
1.
Double-click on the chart.
A gray border appears around the chart and the menu bar now contains
commands for editing the objects in the chart.
2.
Choose Format - Legend or double-click on the legend. This opens the
Legend dialog.
3.
Choose from the available tabs to make modifications, then click OK.
This is no help, as the “available tabs” do *not* allow editing the text
or font.
From the on-line edition of the 4.1 Calc Guide we have, at ppg 88-89:
*Adding or removing chart elements*
/*Legends*/
To add a legend to your chart:
1.
Select the chart by double-clicking on it to enter edit mode. The
chart should now be surrounded by a gray border.
2.
Go to*Insert****>****Legend*onthe main menu bar to open the Legend
dialog. This dialog is similar to the *Display legend*section on the
Chart Wizard dialogshown in Error: Reference source not foundon page
Error: Reference source not found.
3.
Select the *Display legend* checkbox and where you want the legend
displayed on your chart – *Left*, *Right*, *Top* or *Bottom*.
4.
Click *OK*to close the dialog.
5.
Alternatively,right-click inthe chart area and select*Insert
**Legend*from the context menu to insert a legend in the default
position on the right side of the chart.
6.
Click outside the chart to leave edit mode.
To remove a legend from your chart:
1.
Select the chart by double-clicking on it to enter edit mode. The
chart should now be surrounded by a gray border.
2.
Go to*Insert****>****Legend*onthe main menu bar to open the Legend
dialog.
3.
Deselect the *Display legend* checkbox.
4.
Click *OK* to close the dialog.
5.
Alternatively,right-click inthe chart area and
select*Delete****L**egend*from the context menu.
6.
Click outside the chart to leave edit mode.
Again, the user can add or remove, but not edit.
Another dead-end source illuminates another Calc problem:
https://ask.libreoffice.org/en/question/44705/making-a-double-line-graph-with-proper-data-in-libre-office-calc/
<https://ask.libreoffice.org/en/question/44705/making-a-double-line-graph-with-proper-data-in-libre-office-calc/>
This question is “closed” because it was allegedly answered, whilst in
fact no answer of any kind was provided to the basic question “How
*exactly* can I add a 2^nd Y axis and assign different scale to it?”.
Following the given instruction to “Douible /[sic]/ click on the chart,
and then Menu/Insert/Axis, or right-click insert/delete axes” leads to a
menu which allows up to 2 each Y, and 2 each X, axes, but shows no way
to associate a set of figures with the added axes. It must also be
possible to associate colours with the various traces, but how to do
that remains equally a mystery.
Also noteworthy: the OP asked for 2 axes, yet 3 are shewn here, without
instruction as to how to go beyond 2. (The upper illustration raises
more questions, not to be considered here.) One would like to think that
there is no limit to the number of Y axes assignable, but so far only 1
is usable.
Note that only the yellow trace uses the right vertical axis, the other
two use the left. How does one assign any of these traces to a
particular axis, and keep them straight? (Here the unfulfilled “Callout”
icons might be useful, if understood.)
mk
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
