Multiple Level Column Chart

Hey folks... looking for your brilliant help as usual.

I have done a pivot table and made a column chart from it. The chart comes out exactly as I want it, split into different levels (as you can see in the attached "column chart" picture).

I want to know if there is a way to do this without going through the pivot table format i.e. assign different "levels" to data headings as per the pivot table format.

When I try it myself, it shows the "headings" i.e "Job Type 1" etc. as missing information. (See "column chart 2" picture attached).

If anyone has any idea what I'm talking about I'd appreciate the help!

Hello
Perhaps if you lay out your data something like in the attachment. This creates the chart without using a Pivot Table.

Hope this is what you're looking for.

DBY

That's EXACTLY what I'm looking for... for some reason it wouldn't work for me! Thanks. This site never ceases to amaze me.