Stacked Columns with Diagonal Split

[scottyboy218]

Hi - I'm trying to replicate the attached image in Excel with 3 separate columns, is this possible to do in Excel? I've searched the forum and Google extensively and wasn't able to have any luck.

Thank you!

[NickyC]

It looks like this was created as a rough schematic rather than an actual chart. The column widths are not actually proportional to the % members, nor the diagonals to the % costs. So you could reproduce it using shapes rather than a chart.

One way would be:

• create a single elongated short wide rectangle
• set the internal fill pattern to a linear gradient fill
• set the internal gradient with 4 stops at 0%, 49%, 50%, and 51*
• set stops 0% and 49% to red, 50% to white, and 51% to purple
• adjust the gradient angle to make the diagonal run from the bottom left to top right
• to create the appearance of breaks in the column, create two thin rectangle shapes or a thick line the same height as the main shape, and place them over it to create the impression of 3 separate columns

[ben_hensel]

I think you could get within shooting distance with a Stacked Area Chart.

More pertinently,
The chart doesn't add anything you wouldn't find in a table:

Risk	% Pop	% Cost
Low	62	12
Med	34	47
High	4	41

Maybe you could try a cascade chart?