Create a multi-level category chart in Excel

You'll need your data set out so that main categories are in the left hand column of your data table, sub-categories are in the next column, and then your value column(s) are to the right of that. By merging the categories, Excel will create a multi-level category chart when you plot the data. See more details here excelquick.com...