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?

[sunny_talwar]

Try an expression like this for Label on the dimension tab

='Hour (' & vTimeZone & ')'

[Anonymous]

That works! but is there a way to get it only to display only the time and not the date?

[sunny_talwar]

May be like this

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

[Anonymous]

That displays the same results with the date and time

[sunny_talwar]

Can you share a sample to look at?

[Anonymous]

This is all I can provide:

Which is data for the hour field (listed in EST)

[sunny_talwar]

As an image? can you provide this in an Excel file?

[Anonymous]

Yes, here you go- thanks!

[sunny_talwar · Accepted solution]

Seems to work for me