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:

       

      ID,

      PersonName,

      Date,

      Location

       

      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...

       

      Regards,

      Jim