Line Graph With 2 Sets Of Data and Slicer

I'm curious if someone can make a graph for me. It doesn't have to be anything fancy. I'm just trying to learn/see how to convert my data into the proper table formats in order to present it in the graph like I want it. I've attached my example spreadsheet that should be self explanatory. I won't even need any explanations... I just need to see it done so I'll know.

Your help is much appreciated!

Come on ExcelForum gurus... I know you can solve this simple one I either come up with one graph split into 2 sections or one graph that looks like a nightmare

Originally Posted by Kaper

May be try defined names....

This is super close but without the slicer, it would be difficult for people to navigate it. The poor soul who is at the 291 location, for example, would have to click for quite a while to get to the desired data for their facility. I like what you've done, though. Is there any way to adjust it so that a slicer could be utilized. I tried adding one myself but it wipes out the graph.

One small detail, I notice the graph doesn't actually display MON, TUE, WED, etc... it's an overlay. Is there a reason why those categories can't be shown?

My proposition using Power Query and Pivot Table. Maybe it will interest you?

Originally Posted by stasinek

My proposition using Power Query and Pivot Table. Maybe it will interest you?

Very awesome! I've never heard of power query but this was what I was needing. I know how to change over to a line graph if I want but I actually like the columns better now that I see them that way. Thanks so much for doing this. Now, I get to spend some time dissecting how you applied the power query and created pivot table.

Thanks so much!

The EX 2010 add-on should be installed separately (preferably from the official Microsoft website). Your tables have been converted to excel tables (I have cleared the table formatting system). Such tables serve as the source for the PQ query. After merging tables, the query was only in memory and served as an external source for the PivotTable. I think I helped a little in understanding my method of solving your task.

The Power Query add-on to EX 2010 should be installed separately (preferably from the official Microsoft website). Your tables have been converted to excel tables (I have cleared the table formatting system). Such tables serve as the source for the PQ query. After merging tables, the query was only in memory and served as an external source for the PivotTable. I think I helped a little in understanding my method of solving your task.

The Power Query add-on to EX 2010 should be installed separately (preferably from the official Microsoft website).
Your tables have been converted to excel tables (I have cleared the table formatting system).
Such tables serve as the source for the PQ query. After merging tables, the query was only in memory and served as an external source for the PivotTable.
I think I helped a little in understanding my method of solving your task.

Originally Posted by stasinek

I think I helped a little in understanding my method of solving your task.

Yes, you did... thanks again!