Perhaps you should use a relationship instead of a filtered portal to fetch the relevant records. It's rather difficult to be more specific: you describe a single table and a portal - what is the relationship behind the portal? And why not simply find the records you want to chart?
Good point, thanks. That was also an option but it meant having to set up a different relationships for each 'set' of records. But thanks - i did it with your principle in mind. Thanks
If you can set a global field in the parent table to hold the 'DeptCode' value, and base the relationship on this field. Changing the contents of this field will change the relationship, and also the chart. (only 1 relationship necessary)
Message was edited by: brsamuel for spelling corrections.
Thanks, I will give a try.