All Questions
Tagged with charts libreoffice-calc
32
questions
1
vote
0
answers
118
views
How to add a chart that would display 2 values from single row as {X,Y}
In LibreOffice, I have a table like this
Element,X,Y
name1,0,5
name2,1,2
name3,5,7
...
so, I would like a chart that displays dots at {0,5}, {1,2}, {5,7}
as I am trying to use Scatter (XY), all the ...
- 161
1
vote
0
answers
40
views
Graphing coordinates in Calc using direction, distance, and speed
Suppose I have the following data:
Location
Direction (Degrees)
Distance
Speed
Origin
N/A
N/A
N/A
A
090
5
50
B
180
15
75
I can make a chart using the following data to show the path something ...
- 261
1
vote
0
answers
280
views
How to avoid the dreaded Data Table when copying and pasting charts in Libreoffice Calc
Libreoffice Calc has a curious and frustrating behaviour, in that when copying a chart from one tab to another in a workbook, in the majority of cases the duplicated chart is furnished with a copy of ...
- 708
2
votes
1
answer
103
views
Libreoffice: Generate same figure with data in another sheet
I have several sheets with data (corresponding to different years) arranged in the exact same way. I have created figures on sheet 1. Is there a way to have the same figures generated with the data in ...
- 1,070
1
vote
0
answers
195
views
How do I show percentage in a Libreoffice columns chart from fraction data?
I would like to know if there is a way to create a chart in Libreoffice Calc where I get percentage values on the chart from fractions.
Example:
Group 1 4/10 6/10
Group 2 5/10 5/10
I ...
- 11
3
votes
2
answers
1k
views
Libre Office - Single Column Pie Chart
I want to create a pie chart, for a single column that looks like this:
I tried to select the range, click on Insert -> Chart -> Pie-Chart, but regardless of what I try, I always get an empty ...
- 127
0
votes
0
answers
378
views
Scatter chart with corresponding XY pairs
I need to represent data of XY-positions of a series of objects and a test subject's estimations of the positions of those objects. I'd like to pair them in the chart so that you can easily see which ...
- 1
0
votes
1
answer
2k
views
How to plot event times in a LibreOffice-calc chart
I'm trying to make a scatter chart of events, where I have day of week on one axis and time of day on another axis and the data plotted as points for each day+time event.
What I'm trying to get is a ...
- 101
0
votes
1
answer
167
views
Calc pie chart for 25000 rows with long tail
I have a file that contains 25,000 rows, each row containing a number, looking like this:
4000
3000
1500
700
...
2
1
1
1
From this I want to make a pie chart.
The first few pie parts will be ...
- 11.1k
3
votes
0
answers
634
views
When I try to edit Y-axis limit on LibreOffice, the data in the chart disappears
Has anyone encountered such an issue? Am I missing something?
When I choose axis limits manually from Right Click > Format Axis > Scale, the data in the chart disappears or gets hidden. I am ...
4
votes
1
answer
3k
views
Automatically ignore empty rows for diagrams in LibreOffice Calc
The task I am trying to get done is the following (hope I am able to clarify what I mean):
LibreOffice 5.0.5.2
1024 rows of data in a Calc sheet
~256 lines with excerpts of the data right of the ...
- 257
5
votes
1
answer
1k
views
Line chart in LibreOffice - data in rows (type, x, y) rather than in a 2-input table
How do I create a line chart in LibreOffice Calc if the data is organised in 3-tuples rather than in a two-input table?
Example:
Banana Jan 10
Banana Feb 20
Banana Mar 30
Banana ...
- 51
1
vote
1
answer
294
views
stacked area chart with secondary data range
What I have is this:
and I am trying to achieve this:
Using Calc 5, how do I manage the second column to be recognized as secondary data range?
- 551
1
vote
0
answers
78
views
How can I supress zero values in a LibreOffice line line chart? [duplicate]
I'm making a line chart counting users of various releases of a piece of software over the years. This is a very spiky line chart, where as new versions come into existence and then retire, lines ...
- 2,911
2
votes
1
answer
2k
views
Manually "drawing" line graph chart and export data
I would like to manually create a line graph and then sample the created line to generate a data series from it.
Basically I have an idea, what a plotted values should look approximately and would ...
