According my query some time there is no data for certian months.
For example April Total:40, But some time May or June Nor records, becuase of that according my sql query no records going to display on that months.
But i need to show in my Bar graph Aril 2014 to current month(November),
Can some one give me a idea or any comments Highly apriciate.
I found click on Horizontal Axis and goto Options ->Interval type=Number/Months and Interval=1
But its showing only numbers, I try using insert formula to Interval Type Monthname("Month") But no luck
I need to show April,May...until November.
Please check the My attached files With steps
Month(Complain.[Cl Close Date])as Monthname
In the Database this Datetime Filed(Cl Close Date)