Time on Axis of Bar Chart

[alec1982]

hi,

I am trying to build a bar chart with date as my dimension and time as my expression.

the axis shows weird values to the left.. (Image attached)..

Anyone can help me figure out how to fix the axis values to show time..

Sample qvw file attached.

[avinashelite]

Go to Chart properties > Axis >Position > check the right option ..this will give the result

[alec1982]

I dont think so .. that will only switch the numbers to the right side (See attached

[Anonymous]

Badr,

Can you try this??

[alec1982]

when using interval I get weird numbers.. see attached.

[Anil_Babu_Samineni]

Seems, Overlapping. Here, you are calculating Y-Axis as time how year values coming. Can you check other objects any real by. And please share sample so that we will look on this. Why this weird happen?

[Anonymous]

Hi Badr,

can you share sample data.

Thanks,

Raghav

[alec1982]

Here is a sample of my QVW. No overlap from another chart below it..

[alec1982]

still not able to fix it .

[Anonymous]

I just gave it a try with PurgeChar(time([Finish Time]),' AM') as expression instead of time(Finishtime,'hh:mm'). I am not completely aware why it happened. But seems like we got relatively near