How to make a Panel Chart in Excel?
There are 2 approaches to make panel charts in excel. 1. Making one complex chart that internally has panels containing individual charts (requires lots of calculations and chart formatting.) 2. Making different charts and aligning them on excel sheet. There are merits and de-merits both approaches, but I personally prefer #2, since it is very easy to make panel charts with that approach.