I have an excel scatter plot that has plotted random dots within a square and a
ID: 3657733 • Letter: I
Question
I have an excel scatter plot that has plotted random dots within a square and a circle, the circle is within the square. the square and the circle are not shown on the plot, no need and they were calculated using formulas. My goal is to change the color of the dots within the circle region and leave the dots between the square and circle region the default blue color. Is this possible, if so how? I know which points are within the circle, a separate column has identified those dots, but they are not apart of the actual plot. Help!!Explanation / Answer
It's called an X-Y scatter plot. The procedure is different depending on which version you have. Basically, you highlight all of the cells containing, the data; click on 'Insert' then click the icon that looks like a 'dot plot' and it should have the word 'scatter' underneath it.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.