First time here? Check out the FAQ!
I'm working with a chart in Calc and I need to be able to set the X-axis scale resolution to minutes (need 5 minute intervals), but the lowest resolution available is days.
Is there any way to do this with LibreOffice as of the current version (3.6.0)? If not, when will it be added?
Thanks for the hard work! Good product (minus the frustrating limitation). :)
answered 2012-08-16 16:46:34 +0200tohuwawohu
I think the solution depends on two factors:
Assuming your data table looks like this:
with column A using "
Time" cell format;
Then you can simply create a timeline-based chart using the "
X/Y (Scatter)" chart type:
Notice that LO uses time values for the X axis and allows for setting time intervals for that axis (in this case, i did set the major interval of the X axis to "
00:15:00"). Depending on your data types and ranges, maybe you can use similar settings (for five minute intervals: "
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-16 15:48:41 +0200
Seen: 261 times
Last updated: Aug 16 '12