Excel 2013 Pivot Table unable to show Date with AM / PM

Hi Team,

can you help me out here.. I have a excel table that uses Temperatures, Humidity, Date (including AM & PM).

In the "Data" there is a date field which has both a AM & PM. If I have a unique date as per the attachment it plots correctly. But the date should be the same for both the AM & PM values.

If I change the date to reflect this.. ie 17/06/2014 in cell C6 & D6, then 18/06/2014 in cell E6 & F6 then the chart does not plot the data. It plots on the first instance of the date.

Appreciate your help.

Witsend

Hi Team,

Thank you both for your suggestions.... As recommended I changed the chart type and it works a treat thankyou...

Regards

WitsendSolutions