I would like to create a Pivot Chart from the data that I queried. When bringing the Date & Time into the "Drop Category Fields here" it disappears and nothing is shown. I have attached some images of what is going on. I'm wondering if my data is corrupt or there is another issue.
Here is the Data below:
Date & Time Ct 1 Milliamps 11/1/2014 12:01:00 AM 101 11/1/2014 6:00:00 AM 102 11/1/2014 12:00:00 PM 100 11/1/2014 6:00:00 PM 100 11/2/2014 12:01:00 AM 98 11/2/2014 6:00:00 AM 99 11/2/2014 12:00:00 PM 100 11/2/2014 6:00:00 PM 99 11/3/2014
11/3/2014 12:01:00 AM 100 11/3/2014 6:00:00 AM 99 11/3/2014 12:00:00 PM 98 11/3/2014 6:00:00 PM 99 11/4/2014 12:01:00 AM 99 11/4/2014 6:00:00 AM 98 11/4/2014 6:00:00 PM 98 11/5/2014 97 11/5/2014 6:00:00 AM 97 11/5/2014 12:00:00 PM 96 11/5/2014 6:00:00 PM 101 11/6/2014 12:01:00 AM 101 11/6/2014 6:00:00 AM 101 11/6/2014 12:00:00 PM 99 11/6/2014 6:00:00 PM 98 11/7/2014 6:00:00 AM 97 11/7/2014 12:00:00 PM 96 11/7/2014 6:00:00 PM 96 11/8/2014 12:01:00 AM 96 11/8/2014 6:00:00 AM 95