Hi Pamela Germain ,
Thank you for your reply, i tried the method mentioned but i have data only for limited months (June - August), But i am trying to show a chart ranging from Jan to Dec.
It seems that the "Show at Default Value" works by filling in any data between the first and last point of data but doesn't work for dates outside that range
Right, I've run into this myself and since the majority of my data comes from SQL server, I can write a query to add the missing date values as additional rows to make sure every range is available to me. I've also done a secondary data source that is just dates and blended on it, not ideal, but works in a pinch. You might want to search the forum for adding dates to the axis that are outside the available date range and see if anyone has a solution.