Good morning
I am new to this forum so I apologize if I post on an already answered thread.
I am in a bit of a bind.
I am trying to create a scatter chart with four quadrants, with a single data set.
I have been able to create a plotted chart, looks good but there are 2 issues I am running into.
(1) The data points are all over the place.
(1.1) If Q1 (top left) is my HIGH and Q2 (top right) is my MEDHIGH, I would have a data point that is of the same value in both Quadrants.
(2) My data points fall in a linear pattern.
(2.1) I understanding that the X axis would extend as I add data points, but I Need the data points to group together by value in the relevant quadrant.
(2.2) That being said, I do not have a 2nd data set to offset against so I have tried using "1" as a 2nd range range. But still no luck.
I would really appreciate if someone could point me in the right direction.
T
Bookmarks