I have a line chart that shows monthly trends over a two year period. Chart data is sourced from a table that I built using a pivot table and the GetPivotData function. I am also using a drop-down control that allows a user to select among different countries (e.g., US, Canada, Mexico, etc.) My data starts in the middle of the first year and I have not yet reached the end of the second year. As a result I am missing data in the first months of year 1 and the last months of year 2. The starting point will vary by Country.I want to eliminate the lines connecting those missing data points. I have set the data source to treat missing data as gaps. However, the GetPivotData function returns a value of zero for missing data. I have tried replacing zeroes with zero-length strings but it appears that the chart interprets those as a valid data rather than missing data. Any other ideas on how I can eliminate the unsightly chart lines?