Plotting all (x,y) points that make a condition dependent on x and y return TRUE

**JoaoNassif** · 07-23-2021, 02:37 PM

Hello!

Consider that I have a final score (SF), which is calculated by the weighted average of score 1 (S1 - weight 4) and score 2 (S2 - weight 6)
Both scores vary between 0 and 10.

I am trying to plot a graph where the X axis represents S1, the Y axis represents S2, and I need to show on this graph the area which SF>=7.

I cant seem to find a proper graph type to this situation. I´not even sure excel can make such a graph.

I tried combining all possibilities of S1 and S2 in 0,1 increments (resulting in 10.000 lines) and plotting a dispersion graph with the results, but that didnt work as the dispersion graph is limited to 255 points.

Any insights on how to tacke this would be greatly appreciated.

Thanks in advance!

**6StringJazzer** · 07-23-2021, 05:40 PM

Are you trying to plot all possibilities? Or actual scores?

Because of your weights, there are very few possibilities that will give a score <7 (114 out of 10.201). I'm wondering how you will use this chart.

In your example, you used 0,1 increments. Here is the plot I did. I am getting an error and a gap between the two areas, but you can get the idea. I am not sure what you mean by dispersion graph. I am using a scatter chart, which is limited to something like 256.000 points.

**JoaoNassif** · 07-26-2021, 09:25 AM

6StringJazzer, TYSM for your reply.

First of all, let me apologize for my english. I use excel in my native language (portuguese) and when I said "dispersion graph", I meant exactly "scatter chart". I plan to use the chart for a powerpoint presentation where I show the "approved" zone and the "not approved" zone. For some weird reason i am getting an error message saying that my scatter charts are limited to 255 points.

Originally Posted by 6StringJazzer

Because of your weights, there are very few possibilities that will give a score <7 (114 out of 10.201). I'm wondering how you will use this chart.

Regarding the above quote, maybe I wasn't clear also. I am aiming to calculate the weighted average of 2 scores. Both scores (S1 and S2) vary between 0 and 10, which also limits SF to 0<SF<10.

Assuming W stands for weight, the formula for the weighted average should be: ((S1*W1)+(S2*W2))/(W1+W2).

The chart should look like this:
Attachment 741734

It seems that on your workbook, you multiplied the scores by their weights, but didnt divide by the sum of the weights afterwards.

The point to doing this on excel is that the parameters are not defined yet, and I want the chart to update if I update the weights or the minimum SF for approval.

Any further assistance would be greatly appreciated!

**6StringJazzer** · 07-26-2021, 10:58 AM

Yes, I made an error in calculating the weighted average. I did not calculate an average. I will have a second look. If you have a file that shows the error you are getting, that would be helpful.

Your attachment is invalid. If you are attaching an image, I suggest that you first click on Go Advanced under the text area, then attach the image. If you are trying to attach a file:

Under the text box where you type your reply click the Go Advanced button.
On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
Click the Choose File button to select a file to attached.
Click the Upload button to upload the file.
Then click the Close This Window button. Your file is now attached to your post.

**6StringJazzer** · 07-26-2021, 11:13 AM

Here is a revised file. I don't have much intuition about what this chart should look like. I will try to do some validation.

**JoaoNassif** · 07-26-2021, 12:14 PM

Oh, sorry for the bad link! I guess I messed up somewhere

Sem título.png
Attemp 2 to upload
(if this doesnt work, ill upload the image somewhere and post the link)

**JoaoNassif** · 07-26-2021, 12:18 PM

It seems to have worked now! This is a sketch of the graph im trying to do. The closer from (0,0), the farther into the not approved zone you are. The closer to (10,10), the farther into the approved zone you are.and apart from (10,10), the other 2 vertices from the green triangle should show the S1 you need in case your S2 was 10, and vice versa

Plotting all (x,y) points that make a condition dependent on x and y return TRUE

LinkBack

Thread Tools

Rate This Thread

Display

Plotting all (x,y) points that make a condition dependent on x and y return TRUE

Re: Plotting all (x,y) points that make a condition dependent on x and y return TRUE

Re: Plotting all (x,y) points that make a condition dependent on x and y return TRUE

Re: Plotting all (x,y) points that make a condition dependent on x and y return TRUE

Re: Plotting all (x,y) points that make a condition dependent on x and y return TRUE

Re: Plotting all (x,y) points that make a condition dependent on x and y return TRUE

Re: Plotting all (x,y) points that make a condition dependent on x and y return TRUE

Thread Information

Users Browsing this Thread

Similar Threads

Return Two Results if Condition in IF statement is true

Return False or True with condition

VBA for Make a cell blink if Condition True

make OR() return 0 or 1 instead of true and false

[SOLVED] How do I make the true return a drop down list in the IF function?

[SOLVED] RE: If condition is true return sumproduct of two arrays

[SOLVED] If condition is true return sumproduct of two arrays

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions