Excel Charts: Matrix or Excel Panel Charts - Showing many variables at once

Save
2 years ago
20
XelplusVis Advanced Excel Online Course Excel advanced charts and graphs Advanced Excel charts Excel chart tricks Microsoft Excel Tutorials Advanced Excel Tutorials Best Practices for charts in Excel Data Visualization in Excel Advanced Excel Skills Excel for business analysts

Aug 9, 2016 Excel Charts
Complete Advanced Excel Chart Course: http://www.xelplus.com/advancedexcelchartcourse

Download the Excel Workbook Here: http://www.xelplus.com/excel-panel-charts-matrix-excel-charts/

Excel Advanced Charts & Graphs Tutorials: Matrix or Excel Panel Charts - Showing many variables at once

Video Summary:
When you have too much to show in an 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.

âž¹ âž¹ âž¹ My Online Excel Courses âž¹ âž¹ âž¹

Excel Dashboards â–º http://bit.ly/LeilaDashboards
Excel Charts â–º http://bit.ly/LeilaCharts
Advanced Excel â–º http://bit.ly/LeilaAdvancedExcel
Excel Waterfall Charts â–º http://bit.ly/LeilaWaterfall

✉ Subscribe to my Newsletter ✉

Stay informed and get discounts when new courses come out: http://www.xelplus.com/

Loading comments...