• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1158
  • Last Modified:

Excel 2010: Chart Time Intervals

I have a chart that consists of a vertical axis and is in 20 minute intervals (or appears to be so).  I'd like it to be in 5 minute intervals, what's the best way of configuring this to show that?  I'm assuming I'm going to click on the Vertical Axis and choose "Format Axis" then will adjust according in the "Axis Options" section?  Any guidance here is greatly appreciated.  Thank you.

Right now it looks like this:

0.3             <<<<<<         (I'm guessing this reflects 3 hours)

0.25           <<<<<<        (2.2 hours?)

0.2             <<<<<<<      ( 2 hours?)




  • 2
1 Solution
helpfinderIT ConsultantCommented:
You should know what the numbers represents, it´s strange 0.3 is 3 hours, but OK, it could be but then
0.25 is 2,5 hours
0.2 is 2 hours
0.15 is 1,5 hours
0.1 is 1 hour
0.05 is 0,5 hour

then it seems intervals are 0,5 hour (30 minutes)

you can also convert directly in excel that numbers to minutes and use in your axis numbers representing minutes or hours
itsmevicAuthor Commented:
After a little tweaking and peaking I was able to break it down as such:

Minimum:     Auto               0.0
Maximum:    Fixed              8.0    <<<< reflects 8 hour work day
Major unit:   Fixed               .25   <<<< reflects 15 minutes
Minor unit:   Fixed              0.1   <<<<<haven't a clue

I can now distinguish 15 minute increments on the vertical axis.  Granted it's not the prettiest thing but it works.
itsmevicAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now