| View previous topic :: View next topic |
| Author |
Message |
Panik
Newbie
Joined: 09 Dec 2006
Posts: 3
Location: Harrogate, UK
|
 Posted: Fri Dec 15, 2006 8:46 am Post subject: Line chart, x-axis scaled by date, Major interval 1 Month |
 |
|
I am trying to create a chart of currency values over time, to replace a chart that I had setup in MS Excel
I have two columns of data, the date, and the value of an account at that date.
The date is on the X-axis, and the currency value is on the Y-Axis
I originally created the chart as a line chart, but this didn't allow me to change the scale on the X-Axis.
The chart was re-created as an X-Y chart, which looks identical, and allowed me to change the scale on the X-Axis.
The problem is that the scaling is in days, and I would like to scale the date by months, and not every month has the same number of days in it.
Someone else posted the same question here: http://www.oooforum.org/forum/viewtopic.phtml?t=47331&highlight=chart+scale+date
But the answer, to change the chart to a line chart won't work, as a line chart didn't allow me to change the scale of the X-Axis.
Is there any way to scale a date by months, instead of days?
Last edited by Panik on Sat Dec 16, 2006 5:06 am; edited 1 time in total |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri Dec 15, 2006 8:55 am Post subject: Re: Line chart, x-axis scaled by date values |
|
|
| Panik wrote: | I am trying to create a chart of currency values over time, to replace a chart that I had setup in MS Excel
I have two columns of data, the date, and the value of an account at that date.
The date is on the X-axis, and the currency value is on the Y-Axis
I originally created the chart as a line chart, but this didn't allow me to change the scale on the X-Axis.
The chart was re-created as an X-Y chart, which looks identical, and allowed me to change the scale on the X-Axis.
The problem is that the scaling is in days, and I would like to scale the date by months, and not every month has the same number of days in it.
Someone else posted the same question here: http://www.oooforum.org/forum/viewtopic.phtml?t=47331&highlight=chart+scale+date
But the answer, to change the chart to a line chart won't work, as a line chart didn't allow me to change the scale of the X-Axis.
Is there any way to scale a date by months, instead of days? |
Hi Panik
So what you want to do is have a x-axis with the scale in months but irregularly spaced based on the number of days in a month?. I don't know if you can do this, in that the x-axis tick marks seem to be based on a regular interval based on whatever the x-axis variables are.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
Panik
Newbie
Joined: 09 Dec 2006
Posts: 3
Location: Harrogate, UK
|
| Posted: Fri Dec 15, 2006 9:18 am Post subject: Re: Line chart, x-axis scaled by date values |
|
|
| jrkrideau wrote: |
So what you want to do is have a x-axis with the scale in months but irregularly spaced based on the number of days in a month?. I don't know if you can do this, in that the x-axis tick marks seem to be based on a regular interval based on whatever the x-axis variables are. |
Yes, that's what I want to do, so that the Major interval on the X-Axis is 1 Month, and the labels say "Jan 2005, Feb 2006... etc", and correspond to the 1st day of each month.
At the moment I can set the Major interval to 30 days, and the date format to "MMM YYYY", and I get: "Dec 2005, Dec 2005, Jan 2006, March 2006"
Some months are duplicated, and other omitted.
This is something that Excel could do, and I originally had this spreadsheet in Excel, so I have lost this bit of formatting. |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri Dec 15, 2006 9:35 am Post subject: Re: Line chart, x-axis scaled by date values |
|
|
| Panik wrote: | | jrkrideau wrote: |
So what you want to do is have a x-axis with the scale in months but irregularly spaced based on the number of days in a month?. I don't know if you can do this, in that the x-axis tick marks seem to be based on a regular interval based on whatever the x-axis variables are. |
Yes, that's what I want to do, so that the Major interval on the X-Axis is 1 Month, and the labels say "Jan 2005, Feb 2006... etc", and correspond to the 1st day of each month.
At the moment I can set the Major interval to 30 days, and the date format to "MMM YYYY", and I get: "Dec 2005, Dec 2005, Jan 2006, March 2006"
Some months are duplicated, and other omitted.
This is something that Excel could do, and I originally had this spreadsheet in Excel, so I have lost this bit of formatting. |
I'm not a great Calc expert but I don't think you can do this. One place where OOo is definately weaker than Excel is in the Charting module which reportedly is being rewriten to be a bit more sophisticated.
Perhaps some one with more experience in the charting module can help?
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Dec 15, 2006 10:07 am Post subject: |
|
|
Do you want to aggregate the amounts?
Date Amount
[October data]
2006-11-1 100
2006-11-2 200
[December data]
You want the graph sum up 300 for November 2006?
Hu, Excel can do that without pivot tables?
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
Panik
Newbie
Joined: 09 Dec 2006
Posts: 3
Location: Harrogate, UK
|
| Posted: Sat Dec 16, 2006 5:03 am Post subject: Can't be done |
|
|
| Villeroy wrote: | Do you want to aggregate the amounts?
|
Nope.
I want to scale the X-Axis of the chart by the date, with the Major interval set to one month, rather than some number of days
I can do everything, except set the Major interval to be one month.
This is possible in Excel, but as jrkrideau said: | jrkrideau wrote: | | I don't think you can do this. One place where OOo is definately weaker than Excel is in the Charting module |
Thanks for you help everyone, I guess I'll just have to wait until the charting module functionality catches up with Excel.  |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Sat Dec 16, 2006 8:03 am Post subject: Re: Can't be done |
|
|
| Panik wrote: | | Villeroy wrote: | Do you want to aggregate the amounts?
|
Nope.
I want to scale the X-Axis of the chart by the date, with the Major interval set to one month, rather than some number of days
I can do everything, except set the Major interval to be one month.
This is possible in Excel, but as jrkrideau said: | jrkrideau wrote: | | I don't think you can do this. One place where OOo is definately weaker than Excel is in the Charting module |
Thanks for you help everyone, I guess I'll just have to wait until the charting module functionality catches up with Excel. |
Unfortunately that's true. The alternative is to use a dedicated graphing package (which will give you higher quality graphs than any spreadsheet) and insert the results in any text document you are working with. Let's hope the new Calc module is out soon.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
