[Solved] Chart: dates on the X-axis evenly distributed

Discuss the spreadsheet application

[Solved] Chart: dates on the X-axis evenly distributed

Postby thany » Fri May 06, 2011 2:27 pm

I'm having trouble getting dates on the X-axis and having them distribute according to their value. This is not especially specific to dates, but in my case it's about dates. They could be numbers just as well.

Here's what I've got:
24-05-2011 | 30
25-05-2011 | 40
29-05-2011 | 50
30-05-2011 | 60
25-06-2011 | 70

Normally, data like this in a line chart shows a perfectly straight line, but if you look at the dates, the line shouldn't be straight. There's a big gap between the last two dates, which in a line chart should produce a line that's almost horizontal, compared to the other lines.

Basically what I want to see is a graph that shows numbers spread over a whole year, with a number *not* on every day of the year. Still the graph should be plotted of the coarse of a year, not over the coarse of 50 separate days. Having to include days that do not have such a number would be mildly undesirable, but still ok if there's no other way. But even if I include the days between, they'd show up as 0 on the line graph, which is not what I want.

So how do I visualize this kind of data in a line graph neatly and proportionally?
Last edited by Hagar Delest on Fri May 06, 2011 9:36 pm, edited 1 time in total.
Reason: tagged [Solved].
LibreOffice 3.6.4 on Windows 7
thany
 
Posts: 4
Joined: Fri May 06, 2011 1:36 pm

Re: Chart: dates on the X-axis evenly distributed

Postby ken johnson » Fri May 06, 2011 2:39 pm

You should be using the X-Y (Scatter) type of chart.

Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
ken johnson
Volunteer
 
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: Chart: dates on the X-axis evenly distributed

Postby thany » Fri May 06, 2011 7:45 pm

Brilliant, thanks :)

At first I didn't understand how the settings would influence the graph, but I just fiddled with em and it works quite nicely.
LibreOffice 3.6.4 on Windows 7
thany
 
Posts: 4
Joined: Fri May 06, 2011 1:36 pm

Re: Chart: dates on the X-axis evenly distributed

Postby jrkrideau » Sat May 07, 2011 3:53 pm

thany wrote:Brilliant, thanks :)

At first I didn't understand how the settings would influence the graph, but I just fiddled with em and it works quite nicely.


In relatively simple terms, a line chart is just a different version of a bar chart. It assumes that the x-axis is categorical variable : that is 1,2,3,4 is the same as A, B, C, D. just equally spaced labels.

In an x-y graph the numbers on the x-axis are really numbers, not equally spaced labels.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3706
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 36 guests