I'm using a priority column and risk column that I would like to put into a scatter chart. The values I'm using for these columns are High, Medium and Low. I added two additional columns to table A to give each value a score of High = 3, Medium = 2 and Low = 1. I did this for both priority and risk. I want to use the new columns in a scatter chart to see where each priority/risk pair falls.
When I add the two new columns to the scatter chart on the X and Y axis it gives me the 1st picture below. If I add a value to the Details field it complety breaks the chart as you can see in the 2nd picture below
Is there a better way of doing this? How do I get my values to scatter?
Thank you for your response. I got it working to which I have realize I don't think it will give me what I'm looking for. Because each line item will fall into 1 of 9 possible buckets (Risk high, low, medium) vs (Priority high, low, medium) the current will give me just 9 points which what it's showing.
Do you have any suggestion on how I could possibly show the number of line items that fall into each high, low and medium bucket?