How to create a 3-Dimensional 4 Quadrant Matrix Chart in Excel

Поделиться
HTML-код
  • Опубликовано: 27 ноя 2024

Комментарии • 10

  • @daviddifodaysonambago3510
    @daviddifodaysonambago3510 5 месяцев назад

    Thanks for this great video, hope you found the solution for inserting the axis if not, I've figured it out by changing the axis to x=180, y=90% as it will fall in the middle of the chart, then select it and add "Error Bar" percentage, change it to 100% for each, and finally delete the dot in the middle and there you go 😇

  • @louisdeppe6273
    @louisdeppe6273 3 года назад

    Short. Easy. Excellent video.

  • @pamelawade-lehman481
    @pamelawade-lehman481 2 года назад

    This was so helpful!! Thank you so much for posting.

  • @raeburnsmith1
    @raeburnsmith1 7 месяцев назад

    If you want dividers for the 4 quadrants, that adjust according to the average of the Salary (X) and Comp (Y) values, then use Error Bars, as follows.
    Add a series to the bubble chart with a single point, where X and Y are the average of Salary and Comps.Then format the bubble so it is hidden (no fill, no border) and add X and Y error bars which have values that you adjust so they reach to the edges of the chart.
    Thanks to Jon Peltier, aka Mr Excel for this technique.

  • @samanthalockwood3213
    @samanthalockwood3213 Год назад

    Thank you!!!! Very helpful!

  • @michaelkwok8666
    @michaelkwok8666 2 года назад

    Hello, is there any ways to make a 4 dimension 4 quadrant matrix or you will recommend other graphical chart that can do that please?

  • @李筱珺
    @李筱珺 4 года назад

    Thanks for the sharing, I could not find Value from cell when I click Label Option; is there steps missing?

  • @indtechsoftware
    @indtechsoftware Год назад

    Great, thank so much++

  • @musthafabakar9427
    @musthafabakar9427 3 года назад

    Thank you