patelajk Posted July 25, 2008 Report Share Posted July 25, 2008 Hi Is it possible not to chart certain points. E.g. On my X axis I have the Year and on my Y axis the data. What I am trying to do is that if a year is = "-999" then don't chart it (I realise there will be a line missing but this is fine), don't want to to exclude this year from my query (by doing <> -999) as I need to show the year and the missing line will show that data is missing for that year. Hope this makes sense Any examples would be great Thanks Quote Link to comment Share on other sites More sharing options...
Frank Posted July 25, 2008 Report Share Posted July 25, 2008 If the value for that year comes as null from the dataset, the point will be left "hidden" causing a break in the line. So, to achieve this, have your query return null for all years that are -999. Quote Link to comment Share on other sites More sharing options...
patelajk Posted July 25, 2008 Author Report Share Posted July 25, 2008 quick and simple thanks a bunch Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.