formatting datalabel

[serbring]

I plot some values in a pivotchart from a table. I want to format the datalabel like short time 24h. In the table the data are defined as short time 24h.
I have tried to put this code but it doesn't works right.

With ochart.SeriesCollection(i).DataLabelsCollection.Add
     .NumberFormat = Format(Time, "hh.mm")
end with

thank you

 

[RainLover]

I would have thought that you could format the field in Design view using the Properties dialogue box.

By the way. How you format in a table has noting to do with the way it is stored. Dates are stored as decimals. like 23456.001

 

[serbring]

I would have thought that you could format the field in Design view using the Properties dialogue box.

By the way. How you format in a table has noting to do with the way it is stored. Dates are stored as decimals. like 23456.001

thank you for the answer. Yes it is possibile using the propertirs dialogue box but for me i need do it with VBA.