How to Create Panel Charts in Excel | Matrix or Panel Graph in Excel

Master Business Charts in Excel with our course 👉 link.xelplus.c...
In an Excel panel chart (also called matrix or trellis chart), you can show two or more similar sets of data, side-by-side.
⬇️ Download the Excel Workbook here: pages.xelplus....
When you have too much to show in a Microsoft Excel Chart don’t do it in a single graph. It would create a color collage and take too much energy from your readers to try to understand the message. What you can do is create what looks like multiple charts and show them horizontally. You can also create chart matrices. Just make sure that you are consistent by using a common axis, size, color, font, spacing etc. Each Excel chart should look like the identical twin of the other, except that it will show a different series or variable. In the example in the video, we have four companies and we’d like to compare the actual profit and the budgeted profit for each company, against one another. We can do this best by showing them as a panel chart. Because the companies are right beside one another and they share a common axis it is very easy to compare.
Sequencing is also an important parameter to consider when designing panel charts. If you have a specific sequence in the organization that you’d like to keep, you might want to keep that order. However, if that doesn’t apply you can also consider sequencing your charts in ascending or descending order based on the total yearly profit. It really depends on your audience and your message.
To design your panel charts as one chart you will need to have your data in a specific order. It's actually quite easy. Watch the video to find out how.
🌍 Join 400,000+ professionals in our courses ► www.xelplus.co...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel