I pull in data from a MS SQL database, a list of dates with quantities next to them.
Because some dates are missing, I have chosen a scatter chart in order to show these missing dates.
The problem is that my scatter chart is showing an extra day before, and an extra date after my data.
E.g. my data runs from 2017/06/01 to 2017/06/07, but my chart is showing 2017/05/31 to 2017/06/08.
How do I restrict it to the bounds of my data? I don't want to see the last date of the previous month.
I can manually set it in the chart options (i.e.setting the minimum and maximum bounds), but then when my query pulls in fresh data, it won't update to reflect the new data, it will still be set to what I manually typed in.
Because some dates are missing, I have chosen a scatter chart in order to show these missing dates.
The problem is that my scatter chart is showing an extra day before, and an extra date after my data.
E.g. my data runs from 2017/06/01 to 2017/06/07, but my chart is showing 2017/05/31 to 2017/06/08.
How do I restrict it to the bounds of my data? I don't want to see the last date of the previous month.
I can manually set it in the chart options (i.e.setting the minimum and maximum bounds), but then when my query pulls in fresh data, it won't update to reflect the new data, it will still be set to what I manually typed in.