Sorry for the confusing question, I'm not sure how to word it right: here's a mock sample of my data
Name: Cheeseburger Date: 1/20/2011 Stock: 30 Price: 200 Name: Hamburger Date: 1/20/2011 Stock: 12 Price: 180 Name: Cheeseburger Date: 1/21/2011 Stock: 31 Price: 210 ...
I will have to make a table in excel or access capable of looking up the stock and price trends of a particular brand through time.
Trouble is, I have two independent variables (Stock, Price) and two known dependent variables (Name, Date).
So, I cannot use a simple table where the x axis is the name, y axis is the time, and the cells represent a quantity - each cell have to represent two quantities (Stock, Price)
Does anyone know how to do that? Thanks.