User (Legacy) Posted March 21, 2005 Report Share Posted March 21, 2005 I am trying to build a line chart with two series. However, one of those series only has values for some of the data points. The other series has values for every data point. A sample of the data might look like this, where the two series are Region1 and BaseRegion: Qtr Region1 BaseRegion 1998-Q1 NULL 1000 1998-Q2 NULL 1028 1998-Q3 50 1026 1998-Q4 53 1030 However, when I try to chart this, I get zeros printed across the chart instead of the lines (see attached). If I replace the NULL values with 0, the chart will work, but that's not really displaying the data correctly. Is there any way to do this? Thanks, Adrianne Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.