Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have created a combo chart
X-axis : Date
Y-axis 1 : total sales of article 1 in K
Y-axis 2 : total sales of article 2 in M
But the x-axis doesn't display well, dates are all in the center and there is a big blank left and rigth.
Looks like the values on the X axis are not being read as a continuous scale. Under Appearance > X-axis > disable Auto and check Use continuous scale
Also, I'd change the format of the field to a date: =date#(Years, 'YYYY')
Depending on how wide the chart is, it will show you the year or the month as well. See attached
Can you post a screenshot (or even better the app) so that it's easier to pin point the issue?
Thank you Lorenzo.
On the first chart (combo chart) I would like the same display for the x-axis as in chart 2 (simple line chart), more space between the dates
Looks like the values on the X axis are not being read as a continuous scale. Under Appearance > X-axis > disable Auto and check Use continuous scale
Also, I'd change the format of the field to a date: =date#(Years, 'YYYY')
Depending on how wide the chart is, it will show you the year or the month as well. See attached
Perfect! Thank you 🙂