It may be better to wait until indicated in the middle of this protocol before you read it. The need for the “Bottom” area series is discussed at the end of this tutorial. This data will produce this background pattern: ![]() The factor of 1000 is used in the formulas in C8:C11 simply because it will provide the appropriate resolution of the division between shaded areas. The second table above uses formulas that reference the first range: These are static values, but you could put formulas into the range C3:D5 if you wanted the divisions based on the statistics of the data or on any other variable criteria. The axis parameters were selected arbitrarily here, partly to show that the quadrants don’t have to be of equal width or height. Likewise we want them to extend from Y=zero (the bottom of the chart) to Y=9, and from Y=9 to Y=20 (the top of the chart). In this example, we want the areas to extend from X=zero (the left edge of the chart) to X=12, and from X=12 to X=20 (the right edge of the chart). You don’t need to use such a summary table, but you might find it helpful. The first table shows relevant values for the X and Y axis, including the minimum and maximum, as well as where we want the divisions between left and right shaded areas and between upper and lower shaded areas. These two tables show the data and calculations needed to draw the shaded background areas in the chart. The data scales between 0 and 20 on both axes. ![]() Here is the simple XY data used in this tutorial. The protocol has been simplified and the steps reordered to work more reliably in Excel 2013 and other recent Excel versions. The desired end result is something like this: This may help to define certain regions of performance or cost-benefit. People often ask how to shade the background of an XY Scatter chart.
0 Comments
Leave a Reply. |