Scatter chart (to show priority of data)

[Ekaterina]

Hello all.

First off, I would like to say that I know this is not how scatter charts are supposed to be used, but I don't have other ideas. Any other method of doing this would be highly appreciated!

Basically, my data is 12 different categories. Each of them can have a score of 1-5. The score means the following

1-2: High priority
3: Medium priority
4-5: Low priority

So basically, I have 12 different "points" than can be scored on a 1-5 scale. What I want is something like the following (and what I've done so far):

-Taken the data (Value is the actual score, Value2 is something random to test)

imgur: the simple image sharer

-Plotted it in a scatter chart over a false pie chart, to look like the attached file.

But I know that scatter charts work based on the implied formula of these points...

So, I guess what I'm trying to ask is, is there a way for me to do what I'm trying to do? Get the points to appear on the "Low Priority" region if they have a score between 4 and 5, on the "Medium Priority" if the scored between a 3 and 3.99, or on the"Low Priority" if they scored between 1-2.99?

Any help is massively appreciated. Cheers and good day!

 

[Hui]

A couple of questions

The way you've tackled it is fine
It is up to you to define the X & Y values and this will be dependent on the criteria for the scores that you define

Are the Low, Medium and High Priority pie slices fixed or variable in angular size ?
What is the relevance of being close to the center of the pie as opposed to being further out
How important is it that a Low value is 1 or 2 or doesn't it matter same for Med and High scores ?

 

[Ekaterina]

Hi Hui,

Thanks for the reply! Attached is the screenshot of the xls file. Answering your questions, the pie is fixed.
There is no difference if two dots with a value of 1.5 and 1.4 are closer to the center of the pie or closer to its chart boundary as long as there are in the Low values segment and don't overlap.
And lastly, it doesn't matter whether a low value is 1 or 2.