Scatter Plot Gradient Coloring of Markers in Excel

[gaurav_dc]

I have the data of following format.(2 Rows , 4 columns) csv file.
Phylum,Abundance_in_Sample_1,Abundance_in_Sample_2,Abundance_in_Sample_3
Bacteria,6,5,7
I want to plot a scatter plot where Gradients are colored from low abundance (blue) to high abundance (red).
Kindly help.

 

[sijpie]

have you looked here to see if there is a way?

Jon's Excel Charts and Tutorials - Index