18

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?

Improve this question

3 Answers 3

Reset to default
18

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

Improve this answer
4
  • Thanks for responding. So, there's no way to do this with an area chart?
    – Questioner
    Commented Jun 17, 2012 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
    Commented Jun 17, 2012 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...
    – Questioner
    Commented Jun 17, 2012 at 15:54
  • One more thing -- if your date is not properly formatted, you'll have to set the data type of the field manually.
    – Nandakumar Edamana
    Commented Sep 20, 2018 at 2:43
7

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.

Improve this answer
0

Try this:

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

Improve this answer
2
  • 1
    Thanks for answering. Unfortunately, these settings did not change anything.
    – Questioner
    Commented May 15, 2013 at 3:51
  • 3
    Did you try it before posting?
    – underscore_d
    Commented Jan 27, 2018 at 11:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .