Creating a pivot table from 3d data (formatted as such)

[dst112]

Hi,

I am aware that a pivot table can be created from 3d data in the form:
X,Y,Z
X,Y,Z
etc.

However, my data is already formatted as:
_X,X,X
Y,Z,Z,Z
Y,Z,Z,Z

I would like to create a pivot table with the second format so that I can create slicing pivot charts easily. So, is there a way to:
1. Create a pivot table from data formatted in the second fashion?
2. Create pivot charts from the data without going via a pivot table?
3. Easily convert between the two formats?

I am confidant that I can write some VBA to do number 3, I was wondering if there was an automated way to do this already in Excel.

Thanks in advance.