4 Quadrant Scatter Plot Excel Template. Your chart will look like this with the four quadrant picture. Note that we also identify potential crossings for you.
Here is the sample X and Y data with calculated averages and the initial XY scatter. What i am trying to achieve is. Column 1 as X-Axis or 2.
Jul 29 2015 I have written a tutorial showing how to create an Excel Chart With Colored Quadrant Background which was more complicated as it used stacked areas and secondary axes to get the colored backgroundThis is much simpler to create and maintain and serves much the same purpose.
Column 2 as X-Axis. Stars which shows items with High Popularity and High Margins Bottom Right. To create a Quadrant Scatter using QI Macros highlight your two-columns of data. I want to create a scatter four quadrant chart using Excel 2010.
