After that, the chart looks something like this: Select each axis and set the minimum value to -20, maximum value to 20 and major unit to 5. The result should look something like this:įormat each data series to show no markers, but set a visible line. Next, go to edit the data series set:Īdd a second data series with the settings: ![]() Select F2:G3, insert an XY chart and hit OK. Then, a second series is added with the data in F5:G6. ![]() The first step is to create an XY chart from the data in F2:G3. The data series will ultimately be formatted to be hidden, but to start the chart off, they will be visible. The quadrant data series are two dummy series that will be used only to set the X and Y axis for the quadrant dividers. This data will ultimately be plotted on the outer X and Y axes of the chart, which will be formatted to show percentages from 100% down to 0%.įirst, though, we need to take care of the lines that demarcate the quadrants. ![]() For this example, RANDBETWEEN was used to create a data sample with values ranging from 0 to 1. The plotted data points are sourced from these two columns of values. Extra challenge: The X and Y axis run from 100% to 0% instead of the normal 0 to 100.įollowing is a step-by step for creating such a chart. The goal: create a chart in Excel that plots data points on a percentage scale for X and Y, and also shows quadrants with a different scale.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |