NumberFormat property of the chAxis object

[Nick Palmer]

Hi all,

I'm trying to use the NumberFormat property of the chAxis object to control
the way my Axis members are coming out and I'm not having much luck.

My issue is that I have date values my X-axis and the OWC chart is formating
them as dates with the dd/yy/mm format. But what I really want them to come
out is just text. Is there a value that I can set the NumberFormat property
to, to get my values to come out just as I want them and not in formatted
date format ?

Thanks,
Nick

 

[Andi]

Hi all,

I'm trying to use the NumberFormat property of the chAxis object to control
the way my Axis members are coming out and I'm not having much luck.

My issue is that I have date values my X-axis and the OWC chart is formating
them as dates with the dd/yy/mm format. But what I really want them to come
out is just text. Is there a value that I can set the NumberFormat property
to, to get my values to come out just as I want them and not in formatted
date format ?

Thanks,
Nick

Hi Nick,

I have had similar problems to you. Im in the UK and the OWC seems to
think it's on holiday in the US and so converts my UK dates to US ones.
Very annoying. I have read numerous articles saying "just use the
NumberFormat property to change the date to what you want". However
whenever I tried I would always get an error.

What I found was that if your Chart is using bound data you cannot use
the NumberFormat property. If you are populating the Chart using literal
data then you can use the NumberFormat property. God knows why this is
so.

So the only suggestion I have is to use literal data to fill your Chart.

Good luck.

Andi