LINE CHART X-AXIS DATE
This is how Google map displays your Data, If it doesn't have values for any particular date it won't consider that and would simply plot the chart with all available values. However, a database query can be written to even display the dates which aren't there in the database if the dates to be displayed are limited ( e.g. a few days before/after the current date ).
- Sam Lee
- Topic Author
- Fresh Boarder
- Posts: 1
We are trying to create a line chart.
The x-axis (horizontal) is the date.
The data comes from our database.
However not every date has values.
Say we have 1st Mar value 2, 5th Mar value 1 and 8th Mar value 3.
On the x-axis, it only has 1,5 and 8 March, but no 2, 3,4, 6,7 Mar.
And the x-axis spacing is not correct.
1st mar is next to 5th mar which is next to 8th mar.
How to make the x-axis display as date and spaced according to date, even when there are no date and y values (like 2 Mar).