OpenOffice calc colorize data points differently

Question

I gathered some FTP file size statistics for my boss and I wondered if OpenOffice calc had the ability to colorize the data points differently. I want to color green the data points within one standard deviation of the mean, apply yellow to the data points between one and two standard deviations, and red outside of those points. I didn't see how to do that. I don't have the ODS file any more. I deleted it after I got the bell/distribution curve. I used Paint.net to color the appropriate section green. I didn't bother with the yellow and red portions. Below is the graph.

If this isn't possible in OO.o, but is in Excel or Google Spreadsheets, I'm okay using those.

EDIT:

User IQV suggested combining the different XY plots and color the individual lines. Not what I was hoping for, but it does work without having to colorize the lines in a photo editor. I used conditional formatting to color the text cells, and I defined each plot curve by easily picking out the ranges based on the colored cell.

Answer 1

You could do this with an overlay of several x-y-diagrams. You need a column for every color of your diagram. These columns are populated with values corresponding to your needs. Every column gets its own color in the diagram, so you should get your result. This should work in every program.