'How to fix excel printing wrong axis label?
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
sheet.
Solution 1:[1]
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
Dateorcustomand do the changes
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Arun |