It's possible to do the main body of the chart, using a pivot table and the "visual cues" tab in the chart properties to perform the equivalent of an excel conditional formatting on the expression data.
It may be easier to put the summary lines at the top into a different chart object, although there may be workarounds.
