Dear Excel experts,
I have a data in the below tabular format.
1. As first column is time, I want to display HH:MM only. Can you please help me, how to display HH:MM format only.
2. Please find the attached image of the chart. The X Axis text is showing in center. I want to keep text in the bottom.
I have a data in the below tabular format.
9:15:00 | -7.53 |
9:16:00 | -11.72 |
9:17:00 | -6.32 |
9:18:00 | -1.38 |
9:19:00 | -8.25 |
9:20:00 | -3.53 |
9:21:00 | 1.65 |
9:22:00 | -2.12 |
9:23:00 | 4.62 |
9:24:00 | 10.51 |
1. As first column is time, I want to display HH:MM only. Can you please help me, how to display HH:MM format only.
2. Please find the attached image of the chart. The X Axis text is showing in center. I want to keep text in the bottom.