Hello, I am hoping someone can help with my problem.

I am trying to create a pivot chart with data supplied to me weekly.

The date format comes in custom dd/mm/yyyy/hh:mm:ss i.e 08/02/2008/11:12:22

I want to show the amount of pieces of data from each day.

I therefore only need the data to be in the dd/mm format. i.e 08/02

I have tried a helper column and formatted it to dd/mm.

The column looks as I want it too i.e 08/02

When I use the date on the X axis of my pivot chart I cannot stop it reverting back to the original format. So instead of having say a count for each particular day I am getting multiple entries for the same day.

Thanks for any help.