Chart Not Displaying all data on X Axis

[PeakH]

I have a chart that shows total sales for each month. The goal is to show 13 months, including the current month. So for this month it would show Dec 2016 through Dec 2017.


The query my chart is based on is as follows:

SELECT DISTINCTROW MonthName(Month([DelDate]),True) & " " & Year([deldate]) AS DelMo, Sum(RoundReg([TotalPrice],2)) AS RoundTotals
FROM tblOrderConf INNER JOIN tblOrderDetails ON (tblOrderConf.ConfTableID = tblOrderDetails.ConfTableID) AND (tblOrderConf.ConfTableID = tblOrderDetails.ConfTableID)
WHERE (((Year([DelDate])*12+DatePart("m",[DelDate]))>Year(Date())*12+DatePart("m",Date())-13) AND ((tblOrderDetails.TotalPrice)>0) AND ((tblOrderConf.IsSample)=No))
GROUP BY MonthName(Month([DelDate]),True) & " " & Year([deldate]), Year([deldate]), Month([deldate])
ORDER BY Year([deldate]) DESC , Month([deldate]) DESC;

When I run the query everything shows up as expected, but the chart only displays the months in the current year. I have tried getting it to display more of 2016 by going back to November and October, but it still only shows 2017 months.
Any idea why this is happening?

Thanks in advance for the help.

[ranman256]

sometimes ,if the data is in the query, but not on the chart,
you must enlarge the chart and make smaller font and make more room for the values to show.

If there's no room, it only shows some values. Like zooming in to see more.

[PeakH]

That doesn't seem to be the case here. I tried enlarging it to a ridiculous size and still it only shows as far back as January.

[June7]

I analyze chart issues best when I can work with data. If you want to provide, follow instructions at bottom of my post.