Colour between lines on chart
This is typically appropriate between a min and max on the same data-set, so as to show the range in which values occur.
Another use-case is to draw a phase diagram: https://stevengoddard.files.wordpress.com/2010/09/water-phase-diagram1.jpg?w=450&h=420&h=420
There's a workaround to do this for standard charts here, though it's tremendously cumbersome: http://peltiertech.com/fill-under-between-series-in-excel-chart/
It produces a chart looking like this:
I'm more interested in this for PivotCharts where we often look at min, mean, max lines for data together. It would be great to be able to shade or colour between them.
PS: Even to make a min line and max line of the same field have the same colour requires manual intervention at present. It should be possible to apply styles to these as a group somehow (e.g. conditional formatting for charts, css)
Good feedback. We’ll roll this into our plans for new features that we are considering for a future release. Please continue to vote on this feature idea.