Problem using 12-hour time format on X axis of an area chart

[Tuhin_Ghosh]

Hello Everyone, 

I hope you all are doing great.

I am having a problem using an area graph to show hourly call traffic on the Y-axis and time on the X-axis. The X-axis is showing the 24-hour time format, but the client wants to see a 12-hour time format on the X-axis. I am sharing all the screenshots of the same to help you understand the problem well.

I am able to plot the area chart as follows:

But I want to show the area chart as follows:

I have the data as follows:

From the above time column, I have extracted the hour to use the same in the area chart.

Could you please help me out with this?

Thank you in anticipation.

[CNENFRNL · Accepted solution]

[Tuhin_Ghosh]

Thank you so much, sir/ma'am, it's working like a charm. I really appreciate your help.