I have a chart that is pulling data from a table with daily data. The data table starts in the middle of a month. I am charting ~ four months of data and I want the tick marks to be positioned at the first day of the month.
The problem I am having is the data table starts in the middle of the month, which is resulting in the tick marks being placed at the incorrect position on the x-axis. I tried to change the minimum value to the first day of the month but that causes the chart to plot a blank area. I have attached small sample for better clarification. Any comments are appreciated. Thanks
Bookmarks