Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon LINE CHART X-AXIS DATE

More
19 Mar 2018 06:26 #5719

Hi,
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 ).


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Sam Lee
  • Sam Lee's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
10 Mar 2018 12:21 #5674

Hi,
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).
Thanks.
Sam

Please Log in or Create an account to join the conversation.