Forum Discussion
Make Excel Chart from multiple sheets
I hope once again for help with excel, since this community was super helpful before.
I have multiple sheets in a excel sheet and I would like to create a chart that pulls data from multiple of those sheets.
I have Team 1 & Team 2 (on separate sheets within one file) and data on how many people of each team are at any location at any given day of the week. I would like to create a chart that shows the location on the x axis. I would like to show how many people (regardless of team) are at any location each day. If possible it also shows how many people of each team are at Location 1 on Mon, and so on. I am happy to change the data collection sheets as well if that helps.
Played around a bit with your data and came up with an approach that should work on the Mac as well. Use Power Query to combine the two tables and transform the data a bit. Then create a pivot table and pivot chart from it. Would that work for you?
Wow, this is awesome! Thank you so much for your help, this chart was exactly what I hoped for.
