Quadrant Chart in Excel - Excel Tips and Tricks Learn how to draw a Quadrant chart in Excel. This will be an Excel tip on how to make a 4 quadrant chart. Here are the steps outlined in my video. Insert Scatter Chart 1) Insert ~ Scattered Chart 2) Resize and reposition Add Data To Scatter Chart 1) Right-click, Select data 2) Add 3) X-series as "Order Value" 4) Y-series as "Order frequency" Add Average Vertical Axis 1) Add 2) Series Name as "Vertical" X-series as "X" from Vertical table Y-series a

TRANSPOSE Function