How to get chart to display correct label, not the expression itself?

[Anonymous]

I need the x-axis to display the hours, not the expression itself.

For instance if vTimeZone= EST I want the x-axis to look like this:

How can I make this change?

Update:

Under dimensions tab, I selected table then added the expression:

=ConvertToLocalTime(Hour,
if(vTimeZone= 'IST','GMT+09:30',
if(vTimeZone= 'EST','GMT',
if(vTimeZone='GMT','GMT+05:00'))))

Now the chart displays 

How can I just get it to display the time and not the date?  Can I also have it labeled EST?

[Anonymous]

When I used that expression, it changed the output of my graph

from

to

[sunny_talwar]

Did you fix your hour field in the script?

Table:

LOAD Time(If(IsNum(Hour), Hour, Time#(Hour, 'hh:mm')), 'hh:mm') as Hour

FROM

[..\..\Downloads\Hour data.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

I made the fix and it works, thank you for your help!!!