That chart was developed based on the collective input of many members here with real world experience with many/all of the different cameras out there.
You also will see a price correlation between those in red (cheaper) versus those in green (more expensive than those in red).
Generally the larger the sensor, the more light that can be captured per pixel.
What most people don't realize is there is more "pixel screen" material on the 4MP, so two cameras of different MP on the same size sensor will result in the higher MP having more opaque "screen" material that impacts how much light gets thru. So two different cams on same sensor means the lower MP will allow more light on the sensor, so a 4MP on a 1/3" sensor will be much darker than a 720P camera on the same size sensor.
Use a house window for example. Which one is clearer to look thru - the one with a screen or one without? The more holes a screen is produced with, the more material there is as well.
These sensors are small and we need to get as much light to them as possible.
An analogy to try to understand why cameras need so much more light - let's look at an 8MP camera and this 8MP needs at least four times the amount of light as a 2MP for the same sensor. The sensor size is the same in each camera, but when you spread the "screen" of 8MP worth of pixel holes across the same sensor, it now has 4 times the holes, but also 4 times the "screen material" than the 2MP.
Kind of hard to explain, but lets try to use a window screen as an analogy - take a window where the opening is fixed - that is the sensor - you add a screen to it (that represents 2MP) and looking out through the screen is a little darker outside because of the screen material. Now replace that screen with one that has four times the amount of holes (now it represents 8MP) and it will be darker looking through it because (while the resolution would be better) there is a lot more screen material.
So if your house is like most where the top pane is glass with no screen and the bottom half is window with the screen and you see something outside during the daytime - do you sit down to look out through the screen or do you stand up to look a the object through the window with no screen?
And that is accentuated even more at night time. Look out your window with and without the screen and it will be darker looking through the screen than without it. If you are looking out your window to see the stars or the moon, do you look out the part of the window with the screen, or the upper portion without the screen material?
Now obviously as it relates to a camera, you need to balance the amount of pixel holes with the screen material - too few holes (and thus less screen material) and the resolution suffers, and too many holes (and thus more screen material) and the more light that is needed.
Look at a window screen and available meshes. The actual window opening does not change size, so that is the sensor. The screen material is the "pixel screen" that makes up the MP. Which one of these is going to let more light thru?
So if you are taking a 22 mesh screen and trying to get the same amount of brightness thru into the house as the 4 or 14 mesh screen, it will need A LOT more light.
A close comparison would be the 22 mesh screen is an 8MP and the 14 mesh is a 4MP. So if you have the same amount of light going thru a 14 mesh screen as you do a 22 mesh screen, it will be darker for the 22 mesh screen and any parameter adjustment you do to brighten it (gain, iris, brightness) will add more noise.
This is how outside sun shades work. The darker/more shade it provides, the more holes the shade has. More holes equals more screen material which means more light that is needed to penetrate it.
I have a 4MP and 2MP on the same 1/2.8" sensor and the picture quality is quite different between the two and the 2MP kicks it's butt at night.
My 4MP on the 1/1.8" sensor performs better than my 2MP on the 1/2.8" sensor. Even though they are both ideal MP/sensor ratio cameras, the larger sensor has the advantage.
Now this is where you can see the difference about can a camera run in color or B/W for two different MP cameras on the same size sensor.
In most instances, you want to get a camera that will perform at your location for the worse situation, which for most of us is at night when it is dark and there is little to no light. If a camera performs at night, it is easier to tweak settings to make it work during the day than it is the other way around.
My 2MP cameras outperform my neighbors 4K (8MP) cameras....why....because they are both on the same size sensor.
So if low light capability is what one is looking for, you want to be looking for cameras that are on the ideal MP/sensor ratio.