Pivot Chart display problem

[Guest]

I am trying to create a Pivot Chart using two catagories from two different
tables.
One table is called Computer Information, the other is called Employees.
They are related through EmployeeID.
From the Computer Information table I am pulling the catagory called
"status", and from the Employee table I am pulling "office location". Under
"status" there are five types "storage, in service, server, unknown, sold".
Under "office location" there are some 15 locations.
The problem:
When I try to add the catagories "status" and "office location", and put
them into the pivot chart, the status type "Unknown" does not show up as a
display option in the drop down field. However, if I create a Pivot chart
using only the catagory status, all of the types show up correctly. How can
I add both catagories and still see every data type?

thanx

 

[Guest]

What are you including in the query that you base your chart on?

 

[Guest]

I am not using a query, i am just using the data directly from two tables. I
would show you the sql code but it does not give that option on the toolbar
menu.
the tables are layed out as follows:
Computer infomration
computerID
type->desktop-notebook-thin client
date
model
serial number
current status->unknown,in service,server,sold,storage
emplyeeID
Employee
Name
department
office location
employeeID

I am pulling current status from Computer Information and office location
from Employee.