How to fix excel printing wrong axis label?

user_18344831 0
Viewed 23

I want the x label to be datetime just like colum 1, but when i plot the values they turn into number. Dose anyone know why this happens and how i can fix it? Here is a screenshot of the Excel sheet.

excel
1 Answers

You can change the format of the values using following steps:

  • Click the X axis
  • Right click on it and select Formal Axis
  • Select axis option (the icon looks like bar chart) in the right pane
  • Select Numbers -> Category -> Choose the Date or custom and do the changes
user_170156930
Related