How to have two different chart types (one line only the other points only) on the same chart?
if you really mean different chart types then the answer is: You can’t - since the chart type (in Calc’s terminology of chart type) is fixed for a certain chart - it is either a XY(Scatter) or a Line or a Pie (to name few) chart.
However, I interpret your question that you want to format your different data series differently and this can be done. Perform the following:
Right click on the chart -> Edit
- Click on an arbitrary data point of a data series, whose appearance you want to change (all data points get selected by this action)
Right click -> Format Data Series... -> Tab: Line
- Change in drop down Style: from
-none-(or vice versa)
See also the following sample file: FormatDataSeriesDifferently.ods
Hope that helps.
As much as I’d like this answer, but it doesn’t seem to be correct anymore.
At least on Libreoffice 7.4.1 (on Mac here) there is no Option to change the type in the
Format Data Series ... dialog
The whole Tab is missing here.
Looks like major changes in the last 2years
Is there any other way to change the type?
FWIW: I just checked an old file, where I changed types and saved it before. It looks like it loads correctly, so the code for rendering still seems to work fine, but the user interface doesn’t allow to select the functionality.
Thanks I’ve gone back to Excel, pity because i don’t like MS but it works.
Is line there in Safe Mode, Help > Restart in Safe Mode > Continue in Safe Mode?
If it does then look at LibreOffice user profile - The Document Foundation Wiki
BTW I assume you right-clicked on a Data Point, not the background (Format Wall, Format Area)
So, lets try to put that politely: I just invested another half an hour of MY time verifying, that everything here on my side is exactly as I pointed out before already. I wrote about the exact version of the software I’m using. I was using a fresh install already. Nevertheless, I restartet even in Safe mode, just to provide verification, that I’m not a newbie, and that I know where to klick … while on the other hand, Mr “EarnestAI” doesn’t even seem to bother, to invest his own time and look for himself. Why? I don’t get this.
I believe firmly, that this is a feature, that was there once before, alas, I’ve even used it already. Still it is no longer here, and thats what I documented in this thread, to help others, who might look for the feature.
I don’t get it …
So to repeat again: This solution doesn’t work with LibreOffice v7.4.1 on Mac (I cannot and will not say for other platforms) - So either this is a bug in LO or this solution should be marked as deprecated.
A new install does not affect the User Profile, if there is corruption in the profile it is not fixed by a new install.
Safe Mode does not load extensions nor Skia so it removes some possible causes of problems.
The Line tab has not been removed. If it is a bug then it should be reported, How to Report Bugs in LibreOffice - The Document Foundation Wiki
The answer seems to be
if you really mean different chart types then the answer is: You can’t - since the chart type (in Calc’s terminology of chart type is fixed for a certain chart - it is either a XY(Scatter), Line Pie, Column … chart.
However I interpret your question that you want to format your different data series differently and this can be done. the following:
Right click on the chart → Edit
Click on an arbitary data point of a data series, whose appearance you want to change (all data point get selected by this action) Right click -> Format Data Series.. -> Tab: Line
Change in drop down Style: from Continous to -none- (or vice versa)
Why do you repeat my answer instead of accepting the answer by clicking the check mark () next to the answer?