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)
Hello Everyone,
I am trying to chart time values in Excel 2010, Windows 7 Enterprise 64x 8.00gb RAM, I have tried numerous things to try and get the values to display as hh:mm in the axis but I all get is the integer value displayed.
I have tried formatting as text both in the cells and in the axis formatting properties, this has not yielded any success. I have also tried various chart types, all to no effect.
Is this a bug, if so when can we expect a fix from Microsoft, if not what do I need to do to get these values to display as desired?
thank you all in advance.
Regards
Jag
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.
Hello,
Check that the X axis values are really time values, i.e. numbers formatted to show as time. Excel XY charts can show these just fine.
Hello Teylyn,
Thank you for your response, much appreciated.
I have tried what you suggested, which seems to have worked I am just not able to ascertain that as the vertical axis I have formatted has so many values now that it appears as smudges, is there a way to "thin" out the results on the axis to display only the major grid line points?
Regards
Jag
You could apply a filter to the source data. Excel will only plot data that shows in the filtered table.
Hello Teylyn,
The data that is in the column is from a database and as such needs to be there for the graph?
Unless I am not understanding what you are trying to teach me?
I need the values on the axis to show only for the major ticks on the axis, currently all values in the column seem to be showing in the axis.
I must advise that I have two charts types in the one chart, the primary chart is a bar graph, the secondary is a line graph. The line graph is showing values as hh:mm, it is this axis that I am trying to format.
Regards
Jag
OK, looks like you are feeding the whole date/time value to the vertical axis.
Go back to your data source, add a new column and use the formula
=MOD(A2,1)
Replace A2 with the cell that has the complete date/time stamp. Then copy down.
Now use that column for the vertical axis. It will contain only the time part of the date/time stamp.