How to Create a Four Quadrant Chart in Excel | Quadrant Scatter Plot | Quadrant Matrix Chart

preview_player
Показать описание

In this Microsoft Excel video tutorial I demonstrate how to create a quadrant chart. A quadrant chart is a scatter chart where the plot area is divided into four equal parts. In my example I am plotting staff costs against turnover: the branches in the quadrant representing high staffing costs but low turnover are the branches of concern.
------------------------
Рекомендации по теме
Комментарии
Автор

Very clear and insightful video! This one saved me this week! 🙏

meetulshah
Автор

Thank you - super clear! A bad tutorial can be a major timewaster so appreciate your clarity

Intraverse
Автор

Thank you, Chester! Well explained. You've earned that like for sure!

raf
Автор

Great tutorial. Helped me in time of need. Thank you so much.

mathanghidevi
Автор

Very helpful, thank you. I followed along with you step by step and it worked. Thank you!

Pluto
Автор

thank you very much, very easy to understand and helpful

cogiangxcel
Автор

This video was so very helpful. Thank you so much.

scottahrens
Автор

Thank you for this very clear tutorial! Exactly what I needed :)

matthewalford
Автор

Extremely used in marketing. It's a concept similar to SWOT, (Strength, Weakness, Opportunities and Threats). Thank you Chester!!!

IvanCortinas_ES
Автор

Your videos are very informative and useful. Thank you Chester!

sampathkumarvs
Автор

Thanks for posting this video - it was very helpful. How do you handle overlapping labels? In my case, it's common to have multiple records with identical coordinates on the chart. I haven't been able to figure out a way to make the labels readable because they overlap one another.

MattHyatt
Автор

How did we find the x and y of the vertical and horizontal lines?
The average oF turnover and staffing cost?

samkab
Автор

How do you give specific colors to texts within each quadrant?

rodrigobarba