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 😇
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.
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 😇
Short. Easy. Excellent video.
This was so helpful!! Thank you so much for posting.
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.
Thank you!!!! Very helpful!
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?
Thanks for the sharing, I could not find Value from cell when I click Label Option; is there steps missing?
Great, thank so much++
Thank you
You're welcome