Best way to represent this data

Hi all,

So my current task is this:
I have 3 tools and a week of data. There are 4 different shifts.

Here is the data in image:
http://imageshack.us/photo/my-images...pleofdata.gif/

I also uploaded the xlsx file:
http://www.2shared.com/file/OdwswxF1...e_of_data.html

So my 2 issues:
I was hoping to overlay all shifts on one chart. I want to differentiate the shifts by line style or something but keep the tools the same color. Is there a type of graph in excel to do this for me?

2nd issue:
And then with checkboxes next to the tools, if I check it, it will show on the graph, if I uncheck the checkbox it won't show on the graph.

Thanks!

Hi Marvin I created an example of a pivot table Im trying to create. I'm searching through guides but am having a tough time configuring it like this.

So sorry for the double post, I was having hard time editing in the attachments.

Thanks again so much martin! I'll keep trying and let you know if I can't figure it out
THanks so much!

Hi martin thanks so much for your advice. I found the perfect way to show my data.
However I am having one problem.

For the pivot table i want to see it with the "Row Labels" listbox having the items in this order: Week then Shift then Day

But for the corresponding pivot chart I want to see it with the "Axis Fields (Categories)" in the order: Week then Day then Shift

(not the swap in day and shift)

Is there anyway to configure it like this?
I attached the xlsx please see sheet "by week"

Thanks so much!

Hi Martin I have been playing with pivot charts all week and thank you so much for introducing me to them they are so cool!

Actually one last qeustion Martin.

Please see attached file.

So i have these different layers. I want to be able to keep the x-axis of the combined chart constant.

The comnbined chart is a pivot chart so I can filter the layers there, but if i do i dont see the ELot numbers of the others (thex-axis gets cahnged).

Can you please help me to maintain a constant x-axis.

Thanks so much!