Bar Graph for time in H:mm format

  • Thread starter Thread starter kerry78
  • Start date Start date
K

kerry78

:confused: Hi there! I have a problem charting some data....
Column A: I have values of 1 through 23 (these are cycles in m
business)
Column B: I have a different time value associated with coresspondin
cycle in format H:mm

Example:
cycle 1 took 29:55 (29hours and 55minutes)

I need to display as a graph/chart for tomorrow am!


Y axis are my cycles
X axis should be intervals of time in increments of 5 hours

Is it not charting properly because time is displayed H:mm- does i
need to be decimal format? Also, the data i am grabbing is from cell
that have formulas attached, so does that cause a problem....?
Thanks everybody!:

Attachment filename: helpneedchart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=66034
 
Kerry -

If the numbers are entered and recognized as times, you can enter the
axis scale parameters as times. Double click on the axis, and enter 5:00
in the Major Unit box. Excel needs the number 5/24 (or
0.208333333333333, the fraction of a day which is 5 hours), but it will
accept your time input and convert it for you.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You should also check the responses to all the other discussions in the
same newsgroup that you've started on the same subject.
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top