Line charts - please don't join the dots that aren't there! RRS feed

  • Question

  • I have a line chart showing quarterly profit levels on 5 product groups for 2000-2007. Some groups were active for that range, but one started only in 2004 and another in 2006. During the inactive periods the chart should be showing no line at all fro these, but instead it has a horizontal line at the level of the first available data point. In other words it has joined the first dot to a dot that isn't there.

    Anyone seen anything like this? Any idea how to stop it displaying this line?

    This is SQL2005 SSRS SP2.



    Thursday, April 12, 2007 1:24 PM