Share via

Charting time values on X\Y axis not formatting correctly

Anonymous
2014-11-23T18:46:03+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-11-24T19:20:44+00:00

    Hello Teylyn,

    your suggestion did not work as the column that I am using for the time value is already in the hh:mm format and so is not passing anything extra.

    Jag

    0 comments
  2. Anonymous
    2014-11-24T23:42:12+00:00

    What are the settings for the Y axis? Minimum, maximum values? Major unit and minor unit? Maybe you could share a sample file on your OneDrive for inspection?

    0 comments
  3. Anonymous
    2014-11-25T02:08:11+00:00

    OK I have put a copy of the spread sheet on to my OneDrive under the public folder.

    The troublesome sheet is Average Days to Resolve.

    0 comments
  4. Anonymous
    2014-11-25T05:16:37+00:00

    Can you post a link to the file? I cannot get to it otherwise.

    0 comments
  5. Anonymous
    2014-11-25T18:19:33+00:00
    0 comments