2 Replies Latest reply: Aug 6, 2012 4:30 AM by jimmygrollman RSS

    How to create this chart?

      Hello All,

      I have four three items of data:







      I would like to create a chart that has the date accross the top, the location down the left, and the persons name(s) in the middle combined.


      The dates should be distinct, so for example the 1/3/2012 should only appear once and the names will be combined into one field.


      Having difficulties doing this. Have tried to use a straight table and pivot table but have no luck. Names seem to be missing even though selected.


      I would like to have what is shown in the attached excel file. Sample data also attached on second tab.


      Thanks for any help that you could provide...