Solved

Excel 2010:  Chart Time Intervals

Posted on 2013-06-25
3
787 Views
Last Modified: 2013-06-25
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
0
Comment
Question by:itsmevic
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
helpfinder earned 500 total points
ID: 39275733
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
sample2.xlsx
0
 

Author Comment

by:itsmevic
ID: 39275929
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.
0
 

Author Closing Comment

by:itsmevic
ID: 39275933
Thank you.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article will show you how to use shortcut menus in the Access run-time environment.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now