3/30/2024 0 Comments Create xy scatter chart excelThe 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 |