When I create a simple graph like yours, I can duplicate the response with either empty or zero. What I am trying to do is limit the data through a find and still show all values, for example, I limit to only see sales of 25 but I still want to see all names. I have a value list with all names but I am not sure how to get the graph to use the list to show the names without sales of 25, I would still like to see Sally, George, and Karen on the graph with no data along with the 2 that have 25 in Sales. Is this possible? Thanks. Faith
Yes Faith, it is possible... but I think you need to go about it in a different way.
Instead of having the Names as just a valuelist, you could have them as records in a "Salesperson" table.
Then you make a relationship with your actual sales info and use the names from the Salesperson table to match with the name field in the Sales table.
Then from the Salesperson table you can show the related sales totals by creating a "summary" field in the Sales table which gives the total of "total" field.
So from the Salesperson table you can chart both name and Sales::TotalSales for the found set of records.
I hope this makes sense...