For “ Series Y values,” select all the values in column Revenue ( column C).For “ Series X values,” highlight all the values in column Expenses ( column B).Under Legend Entries (Series), click the “ Add” button. Right-click on the chart area and choose “ Select Data.”Īnother menu will come up. Once the empty chart appears, add the values from the table with your actual data. Click the “ Insert Scatter (X, Y) or Bubble Chart.”.Building the chart from scratch ensures that nothing gets lost along the way.
Why empty? Because as experience shows, Excel may simply leave out some of the values when you plot an XY scatter chart. Step #1: Create an empty XY scatter chart. Here is a sample table showing the amount of money spent on each marketing channel along with the revenue it generated: In this case, the quadrants will split the chart into four areas, effectively grouping together the best- and worst-performing options to help you make well-informed decisions. What should be prioritized, and what should be cast aside?
#EXCEL SCATTER PLOT HOW TO#
In this step-by-step tutorial, you will learn how to plot this highly customizable Excel quadrant chart from the ground up:įor illustration purposes, let’s assume you have set your mind to track the performance of every marketing channel your high-end brand is using and separate the wheat from the chaff. Check out the Chart Creator Add-in, a newbie-friendly tool for creating advanced Excel charts in just a few clicks. Unfortunately, the chart is not supported in Excel, meaning you will have to build it from scratch on your own. The purpose of the quadrant chart is to group values into distinct categories based on your criteria-for instance, in PEST or SWOT analysis. In its essence, a quadrant chart is a scatter plot with the background split into four equal sections (quadrants).
0 kommentar(er)
