Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an area chart in LibreOffice Calc where I would like the X axis to be measured in one month intervals spaced evenly apart.

The data going into the graph, however, is not regularly spaced at one month. There can be zero, one, or two entries in any given month.

Right now, the chart is keeping the horizontal pacing of the data consistent and adjusting the X axis to accomodate, which is the reverse of what I want. In the example picture below, you can see that there is one data point in March, one in May, and two in June. Along the X axis, April is gone and June is taking up double the space.

chart example

Instead of this, I'd like the months to stay the same spacing so there is April, May, and June, and for the data area of the chart to compress or extend horiozontally as necessary. I have tried editing the X axis and adjusting the time intervals, but this doesn't seem to do anything.

Is what I'm after possible?

share|improve this question
add comment

3 Answers 3

up vote 6 down vote accepted

Yes, this is possible. You need to select the XY (Scatter)chart type. If you start with this data table:

data table

..., select it, start the chart wizard and select XY (Scatter), the result preview already shows that the data points are córrectly spaced:

chart wizard

(NB: i didn't customize the wizard's defaults yet - Calc did recognize the columns correctly).

The only problem is that you still can't tell Calc to use "one month" as scaling unit for the X axis. This means, the scale of the X axis will use days as scaling unit. If you set the major interval of the X axis to 30 (days), the resulting chart will look like this:

chart

share|improve this answer
    
Thanks for responding. So, there's no way to do this with an area chart? –  Dave M G Jun 17 '12 at 12:11
    
AFAIK no, you can't combine XY (Scatter) with Area. And within a XY chart, you can't change the lines to areas (again AFAIK). –  tohuwawohu Jun 17 '12 at 13:37
1  
I really need to do this with an area chart, not with lines. I guess I need to find other software then... –  Dave M G Jun 17 '12 at 15:54
add comment

Try this:

Format the X Axis, Scale Type: Date Minimum: Automatic Maximum: Automatic Resolution: Days Major Interval: 1 Months Minor Interval: Automatic.

share|improve this answer
    
Thanks for answering. Unfortunately, these settings did not change anything. –  Dave M G May 15 '13 at 3:51
add comment

Yes, you need other software, such as MS Excel. What you are looking for is a missing feature in Libre Office Charts.

Many people would like to have the ability to plot a date on the X-axis when using area charts, but the software only supports the use of ORDINAL numbers. This is a glaring defect in the software that has been present for a long time. There seems to be no interest in fixing the problem.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.