charts use a "found set" of records (unless you are calculating out the values)
Change your find based on what you want to see, then display the chart.
ok i will try - currently have been using data from related table though
is it possible to maybe create another linked table that shows just the found data? when i try to display current found set it isn't really working
Edit: have worked this out now
also, is it possible to change chart colors/styles based on field values. eg. if the estimated time remaining is negative (the user has used more than allocated time to complete task) the color of the that point on the chart changes to red?
anyone got a suggestion for this?