Hi guys, this is driving me up a wall.
I've attached a table that looks fairly similar to my data.
For each thing, which has its own ID, it goes through Step 1, 2, and 3 - but not everything goes through every step.
What I would like is a graph of the data that shows all of step 1, all of step 2, and all of step 3 as different line graphs so that they will look something like the third image on this page: http://peltiertech.com/WordPress/gro...a-pivot-table/

I think my problem is that I can't get the data in the axis fields to become un-hierarchical - so when you look at ID 18, since it doesn't have a step 1, it will never display a step 2.
I would also like the data to display by month - for example, IDs 10-13 should show up as one variable on the x axis because they are in the same month and return the value "4" on the y axis.

Thanks so much for any help!

example.xlsx