Hello. I appreciate that this may be pressing the limits of what excel can do and may not be possible.
What I want to do is as follows:-
I have a spread sheet, and on this spread sheet it has the dates that an item entered a particular unit of storage, and when it left a particular unit of storage.
So the spreadsheet looks like this
Coloumn F Coloumn U Column V Column Z
Name of item Date entered Date left Unit of storage
Item A 01/04/2012 01/07/2012 Unit 1
Item B 05/06/2012 30/06/2012 Unit 2
Item C 01/05/2012 01/08/2012 Unit 1
Item D 01/05/2012 14/05/2012 Unit 3
Item D 15/05/2012 01/08/2012 Unit 1
The items keep on going down, (a lot of columns have been missed out as they include information we need, but not for this purpose) there are a good couple of hundred items and some of them appear multiple times (as we still hold the, they are just transferred from one unit of storage to another)
What I want, is to try and work out how many items are in a particular unit on a certain date and display it on a line graph. (though I appreciate it may be much easier to do t on mulitple graphs, with a grap for each unit, there are a small number of units in total, around 8)
i.e.
The X axis of the line graph would be the date going forward on a daily basis
The Y axis of the line graph would be the amount of items
The colour of the line would dictate which unit of storage it was unless using seperate graphs for each unit
That way, I could put a horizontal line on the graph (this horizontal line would mark the maximum number of units that we should be storing) so I can see at which points we are exceeding maximum storage.
The above point may be why it is better to use different graphs as each unit has a different storage capacity and as such the graph could look quite messy if all the lines are stuck on one.
What I want to do is as follows:-
I have a spread sheet, and on this spread sheet it has the dates that an item entered a particular unit of storage, and when it left a particular unit of storage.
So the spreadsheet looks like this
Coloumn F Coloumn U Column V Column Z
Name of item Date entered Date left Unit of storage
Item A 01/04/2012 01/07/2012 Unit 1
Item B 05/06/2012 30/06/2012 Unit 2
Item C 01/05/2012 01/08/2012 Unit 1
Item D 01/05/2012 14/05/2012 Unit 3
Item D 15/05/2012 01/08/2012 Unit 1
The items keep on going down, (a lot of columns have been missed out as they include information we need, but not for this purpose) there are a good couple of hundred items and some of them appear multiple times (as we still hold the, they are just transferred from one unit of storage to another)
What I want, is to try and work out how many items are in a particular unit on a certain date and display it on a line graph. (though I appreciate it may be much easier to do t on mulitple graphs, with a grap for each unit, there are a small number of units in total, around 8)
i.e.
The X axis of the line graph would be the date going forward on a daily basis
The Y axis of the line graph would be the amount of items
The colour of the line would dictate which unit of storage it was unless using seperate graphs for each unit
That way, I could put a horizontal line on the graph (this horizontal line would mark the maximum number of units that we should be storing) so I can see at which points we are exceeding maximum storage.
The above point may be why it is better to use different graphs as each unit has a different storage capacity and as such the graph could look quite messy if all the lines are stuck on one.