MS Access Graph Clustered Chart X Axis issue

[prabhus]

Hi,

I have table with data from 2010 to 2015 by month, in my access graph i have option for the user to select the year and view the graph. I used a Query to do this and linked the query to the graph.
Everything working fine when the user select the year graph appears for the right selection but the X axis category always showing Jan-15 to Dec-15. Even when choose the data for 2010, i still get X-axis category Jan-15 to Dec-15.
Please help!!!

 

[Ranman256]

in the query ,have your fields formatted:
format([date],"yyyy-mm") as mo

you may have to do it in the chart.