Scatter points on charts to display colour of numbers in data cell

[dewotorf]

How do i get scatter points in excel charts to display the colour of the reference data. For example in the attached, how do I get all cells coloured red to display the scatter bubble as red, green for cells with green etc.

 

[dewotorf]

color scatter sample.xlsx
	Q
12
Sheet1

 

[AhoyNC]

See if this link helps.

How to add conditional colouring to Scatterplots in Excel

There isnt a straightforward way to add conditional colouring to scatterplots in excel, but with a little data wrangling, its very easy to do.

daydreamingnumbers.com