Home » Accounting » How to Make Quadrant Chart in Excel

How to Make Quadrant Chart in Excel

Download Business Management Templates Excel Dashboards KPI Reports


How to Create an Excel Quadrant Chart
Excel quadrant chart will center horizontal X axis and vertical Y-axis in middle of the chart. This placement divides chart in to 4 quadrants, where poor and positive data are plotted. Majority excel spreadsheet applications like excel and OpenOffice Calc make quadrant charts making use of the scatter graph selection. Altering the minimal and optimum values for every axis in scatter graph makes uniform quadrants with regard to the data plots. Type the X axis information in column A. Type the Y axis data in column B. For instance, you may type X and Y coordinates within columns A and B.
Click the layout options. Select Axes out of the Axes category, point to main Horizontal Axis and choose even more main Horizontal Axis Options. Select solved out of the minimal and optimum options in the Axis options excel tab. Type equivalent poor and positive values in every area. Make sure that the selection is big sufficient to accommodate every data value. For instance, in case the lowest data result is poor ten and highest result is ten, you will type ten and ten for minimal and optimum values. Automatically, axis titles show up alongside the axis. To put titles at the end of chart, choose Low out of the Axis titles drop down options.
Click Line design out of the left pane. Select strong design out of the right pane. Choose the chosen design, like strong black, out of the design drop down options. Performing this prepares the center axis even more recognizable. Select Close. Enter the identical minimal and optimum values you typed previously for horizontal axis. In instance, you will type ten and ten for minimal and optimum values. Choose Low out of the Axis titles drop down options to turn the axis titles to left.
Click Line design out of the left pane. Select strong Line and choose the identical design you previously chosen. Select Close to finish the quadrant chart. Click structure, Axis and then X Axis. Click on the Scale tab and now uncheck automated out of the minimal and optimum options. Type minimal and optimum selection values for quadrant chart. Click on Positioning tab. Click on the Place titles drop down options and choose Outside Start. Doing this locations the axis titles at the end of chart. Select ok. Click structure, Axis and then Y-axis. Type the minimal and optimum selection, line design and label location, particularly when you did for X Axis. Use ok to comprehensive the quadrant chart.

Download Business Management Templates Excel Dashboards KPI Reports