itsmevic
asked on
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?)
0.15
0.1
0.05
0
Right now it looks like this:
0.3 <<<<<< (I'm guessing this reflects 3 hours)
0.25 <<<<<< (2.2 hours?)
0.2 <<<<<<< ( 2 hours?)
0.15
0.1
0.05
0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
ASKER
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.