Hello, I am wondering how to create an x axis with labels on both major and minor ticks indicating larger and smaller units, for example: I would like to create a chart with a large number on the x axis increasing from 1 to 4 representing days with 24 smaller numbers between each big number representing hours. Is this possible?
You can not use different size numbers on one x axis. You need use more than one x axes if you want to frmat them differentially.
.
Depending on the fact which type of the graph want you create: the possibilities may different. Is that is an X-Y chart or a simple line chart?
.
Please upload your .ods type sample file here.
Tips:
- Use two x-axes with different format properties.
- Try to use custom labels for the x-axis.
+1 tip:
A workaround tip:
Create your own “virtual x-axis” (a horizontal graph line - based on same constant values, but with custom labels) may help you.
Here is a sample file with DateTime values on the x-axes. The x-axes are formatted and positioned differently. (It is an X-Y type of graph.)
DateTime.ods (32.8 KB)