I want to create an exploding stacked column chart similar to this:
For example, I want to create the graph from the following data:
+--------------------------------+--------+--------+
| Process | Solid | Liquid |
+--------------------------------+--------+--------+
| Workover & Well Intervention | 90.73% | 5.76% |
+--------------------------------+--------+--------+
| WTP | 9.27% | |
+--------------------------------+--------+--------+
| SP | | 40.58% |
+--------------------------------+--------+--------+
| SPU | | 53.66% |
+--------------------------------+--------+--------+
| Workover & Well Intervention 1 | 35% | |
+--------------------------------+--------+--------+
| Workover & Well Intervention 2 | 52% | |
+--------------------------------+--------+--------+
| Workover & Well Intervention 3 | 12% | |
+--------------------------------+--------+--------+
| SPU – Demulsifier | | 59% |
+--------------------------------+--------+--------+
| SPU – Deoiler | | 41% |
+--------------------------------+--------+--------+
Note: to import the data into your own spreadsheet, select the whole table and copy/paste it into your workbook, say in A1. Select what's in column A and click Text to Columns. Select Delimited data, and enter the fence character as the delimiter. Click Finish. There will be a bunch of border stuff in column A; just delete column A.
In this case, I'd like to explain the Workover & Well Intervention and the SPU data from the first 4 rows with the details provided within the last rows. Anyone knows how should I proceed? I am using Microsoft Excel for Mac 2011