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 tho...
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.