This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a simple bar chart where the data is formatted as date and the values on the axis show up as dates. I want to have months as units on the axis but the option of changing axis units does not appear in Axis options (I can only choose display units in hundreds, thousands etc.). Pls advice.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Excel lacks the concept of a time-scale value axis, it is always a numeric scale (even if the axis labels are formatted as dates).
Not true. I have a pair of charts. One shows an option row under Axis Options for "base unit" which allows for selecting days, months, or years. The other chart, which also has dates for the x axis, does not show that option row in Axis Options. Something is wrong.
Hi,
You have to right click on the X axis dates > Format Axis. Are you mistakenly right clicking on the Y axis numbers instead?
I had interpreted the original question to be about the value (Y) axis, not about the category (X) axis.