help!save my job...charting time is causing me headache!

: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!:) 
PS: I am not at work now-so cant attach file for review, but will sen
to anyone willing to help in the a

--
Message posted from http://www.ExcelForum.com

0
8/26/2004 1:20:41 AM
excel.charting 18370 articles. 0 followers. Follow

4 Replies
290 Views

Similar Articles

[PageSpeed] 40

Hi, Kerry,

The H:mm format doesn't mean number of hours and minutes, 
it's hour and minute of the day ... so it doesn't really 
match what you're looking for (that format can't exceed 
24:00)

Using decimals would be more accurate for the numbers you 
need if you can display them in that way.

Let me know if you need a work around to display the 
numbers in that format.

Stephanie Krieger
author of Microsoft Office Document Designer
(from Microsoft Press)
e-mail: MODD_2003NOSPAM@msn.com
blog: arouet.net

>-----Original Message-----
>:confused: Hi there! I have a problem charting some 
data....
>Column A: I have values of 1 through 23 (these are 
cycles in my
>business)
>Column B: I have a different time value associated with 
coressponding
>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 it
>need to be decimal format? Also, the data i am grabbing 
is from cells
>that have formulas attached, so does that cause a 
problem....?
>Thanks everybody!:) 
>PS: I am not at work now-so cant attach file for review, 
but will send
>to anyone willing to help in the am
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
8/26/2004 2:08:31 PM
Is the time really a time as understood by XL?  If so, the format 
(Format | Cells... | Number tab) should be [h]:mm and *not* H:mm

Once that is resolved, create a bar chart.  Select the column A:B data, 
click the chart wizard and select the Bar chart type.  This consists of 
horizontal bars and will give you what you want.

-- 
Regards,

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

In article <kerry78.1bkngf@excelforum-nospam.com>, kerry78 
<<kerry78.1bkngf@excelforum-nospam.com>> says...
> :confused: Hi there! I have a problem charting some data....
> Column A: I have values of 1 through 23 (these are cycles in my
> business)
> Column B: I have a different time value associated with coressponding
> 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 it
> need to be decimal format? Also, the data i am grabbing is from cells
> that have formulas attached, so does that cause a problem....?
> Thanks everybody!:) 
> PS: I am not at work now-so cant attach file for review, but will send
> to anyone willing to help in the am
> 
> 
> ---
> Message posted from http://www.ExcelForum.com/
> 
> 
0
8/26/2004 2:46:28 PM
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

In article <kerry78.1bkngf@excelforum-nospam.com>, kerry78 
<<kerry78.1bkngf@excelforum-nospam.com>> says...
> :confused: Hi there! I have a problem charting some data....
> Column A: I have values of 1 through 23 (these are cycles in my
> business)
> Column B: I have a different time value associated with coressponding
> 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 it
> need to be decimal format? Also, the data i am grabbing is from cells
> that have formulas attached, so does that cause a problem....?
> Thanks everybody!:) 
> PS: I am not at work now-so cant attach file for review, but will send
> to anyone willing to help in the am
> 
> 
> ---
> Message posted from http://www.ExcelForum.com/
> 
> 
0
8/26/2004 2:50:39 PM
The number formats specify how Excel displays a number, which may be 
stored internally in a very different way.

Using a number format of [h]:mm allows the display to exceed 24:00. It's 
important to know that Excel stores times as a fraction of a 24-hour 
day. 0:00 is zero, 6:00 is 0.25, 12:00 is 0.5, 24:00 is 1.0, and 30:00 
would be 1.25.

If you used a number format of h:mm, without the brackets, 24:00 would 
appear as 0:00 and 30:00 as 6:00, because it would not show beyond 24:00 
(or 1.0). Without specifying a date portion of the number format, 
there's no way to show the 24-hour units.

Dates are stored as the whole numbers, indicating days since a reference 
point of 1 January, 1900, including 29 February, 1900, because everyone 
but the Lotus programmers know that 1900 isn't a leap year (and either 
the MS programmers kept the error for compatibility, or they didn't know 
about non leap years either). Today is 38226. Today at 6 am was 
38226.25, and tomorrow at 6 am is 38227.25. You would use a number 
format like d mmm yyyy h:mm to display them as 27 Aug 2004 6:00 and 28 
Aug 2004 6:00.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Stephanie Krieger wrote:

> Hi, Kerry,
> 
> The H:mm format doesn't mean number of hours and minutes, 
> it's hour and minute of the day ... so it doesn't really 
> match what you're looking for (that format can't exceed 
> 24:00)
> 
> Using decimals would be more accurate for the numbers you 
> need if you can display them in that way.
> 
> Let me know if you need a work around to display the 
> numbers in that format.
> 
> Stephanie Krieger
> author of Microsoft Office Document Designer
> (from Microsoft Press)
> e-mail: MODD_2003NOSPAM@msn.com
> blog: arouet.net
> 
> 
>>-----Original Message-----
>>:confused: Hi there! I have a problem charting some 
> 
> data....
> 
>>Column A: I have values of 1 through 23 (these are 
> 
> cycles in my
> 
>>business)
>>Column B: I have a different time value associated with 
> 
> coressponding
> 
>>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 it
> 
>>need to be decimal format? Also, the data i am grabbing 
> 
> is from cells
> 
>>that have formulas attached, so does that cause a 
> 
> problem....?
> 
>>Thanks everybody!:) 
>>PS: I am not at work now-so cant attach file for review, 
> 
> but will send
> 
>>to anyone willing to help in the am
>>
>>
>>---
>>Message posted from http://www.ExcelForum.com/
>>
>>.
>>

0
8/27/2004 4:56:45 PM
Reply:

Similar Artilces:

please help me
915 441722 COTTRELL, ERIN M 915 Total 922 155872 SABIN, DEAN I need to insert a page break after 915 Total, but leave the blank line above 922. -- yepidu I hope that the below link will help you... http://www.microsoft.com/office/community/en-us/default.mspx?&query=MarkN&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.misc&p=1&tid=641f4360-7ad4-47d3-ac41-716c205d07ea&mid=641f4360-7ad4-47d3-ac41-716c205d07ea -------------------- (Ms-Exl-Learner) -------------------- "yepidu" wrote: > 915 441722 COTTR...

UI help
Hi, I started programming with C#, so I'm a newb. I recently had to take over a project here at work that is an MFC based tool, I have a particular UI need and I'm not sure of the best way to solve it. I have a section of the CDialog that I would like to show a series of CEdit controls. Each CEdit control will get a CStatic label above it. Depending on what item the user has selected in the tree, I need to show a different set of CEdit controls and CStatic controls. What seems logical is to somehow place all these controls onto "Panels" then hide and show as needed. I f...

chart area line missing in one pace (with picture)
http://immunizecaadults.org/images/trig.jpg Can anyone tell me why there's a piece of line in the chart area border missing? I checked, and there is no object floating over it. Thanks. If you change the size of the chart area, does the missing postion stay the same? if you change the backgrond color of the chart, what do you see? If you move the chart area in the chart doc, what do you see? If you regenerate the chart what do you get? In other words, I don't know what causes it. "Dave R." wrote: > http://immunizecaadults.org/images/trig.jpg > > Can anyone...

Help on subscript out of range error (VB6/VBA)
Hi, I want to work with multiple excel workbooks en worksheets using a stand alone VB6 application. 1. First I open and close the workbooks and populate a listbox with sheetnames. 2. Then I select some sheets and fill an Array. (This array contains sheetnames from different workbooks) 3. The last step is to open and close the workbooks again and loop (For Each) through the sheets to get the information I need using the above mentioned array. The only problem is that I receive an "Subscript out of Range" error. This error occurs because I'm attempting tot access a workshee...

Combining multiple Stacked Charts
I have 3 scenarios with info on Asset A and Asset B for 10 years. I can create stack charts for each scenario independently, but can not figure out how to combine all 3 onto 1 chart across multiple years. x axis is year and each year should have 3 stacked lines Y Axis should be total value of both Assets Any help appreciated Does this help? http://peltiertech.com/WordPress/2008/05/19/clustered-stacked-column-charts/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JANeyer" <...

Any Help documentation for Exchange 2007?
E2k7' help button gives 'Cannot display Help' Technical details: HC not found. (MS.OSSADMIN.manifest , 1033) Did I miss something? Not all the help is completed in the Beta 2 release. "Prem" <premmetje@zonnet.nl> wrote in message news:1161634519.758601.285030@i42g2000cwa.googlegroups.com... > E2k7' help button gives 'Cannot display Help' Technical details: HC not > found. (MS.OSSADMIN.manifest , 1033) > Did I miss something? > ...

Deactivating an embedded chart
Is it possible to deactivate an embedded chart (chart in a worksheet, not a chartsheet). I have an embedded chart that has a large data source range (about 10,000 cells) and a VBA macro that performs some calculations and inputs the results into these cells, but the chart updates in realtime and it slows the macro down quite a lot. I have read that the following code could be used if the chart is in its own chartsheet: Code: -------------------- Private Sub Chart_Deactivate -------------------- But my chart is embedded, so how could I deactivate/reactivate it? Alternatively, I though...

Symbols in Excel 2007 Chart
Dear Group, Hello. I would like to use the greek mu symbol in an Excel 2007 histogram. I am able to convert the "m" into the proper "mu" symbol in the spreadsheet itself but this is not reflected in the resulting graphic. I need for my X axis label to be represented by the proper greek letter, not m. Does anyone know how to fix this issue? Thank you in advance. John McLaughlin In many fonts, holding Alt while typing 0181 on the numeric keypad produces �. This means you don't have to change the font for some of the characters in a text element (and many tex...

HELP! **Transfer orders to invoices error
I need some serious help. We just upgraded from GP 7.5 to GP 8.0 and now I am unable to transfer orders to invoices. I keep getting an error that says "Order ORD1555 has no line items to transfer to Invoice INV144408." Order# 1555 does have about 10 line items, which I can view on the screen. I did go in and run the "Check Links" function, but it hasn't done anything. This is our busiest time of year and a really bad time for something like this to happen. Can someone please give me some advice on how to fix this? if this is just one order, why not cancel...

Cascading Combo for Chart Source
I have found some examples of how to use a combo to set the data source of an excel chart (see http://peltiertech.com/Excel/Charts/ChartByControl.html), using a combo to set an offset. In this case I'd have a combo box of counties which return number which is used as the offset. The relevant row is then used as the source for the chart. COUNTY WEEK01 WEEK02 WEEK03 WEEK04 Staffordshire 1.1 1.2 1.4 2.1 Derbysire 2.1 3.3 4.1 2.2 .... However, I have another spreadsheet that has the monitoring stations within counties. There are hundreds so it wouldn'...

Pls, help a beginner(MFC)
Could anybody tell me what is the future of MFC? I never used that library. I just got some skills in pure C++. But some knowledgeable people are saying it's not a good idea to study MFC, because "it's going to be obsolete" and replaced by .Net. They advise me to study C# because as they say "studying MFC will take you quite a lot of time by which Longhorn will be released and all coding will be done in managed way"... Well, I really don't know which direction to elect According to me :) MFC never be obsolete and it would be safe...

Move a single org chart shape
This is a simple question (I hope). I am trying to reduce the vertical space between the shapes at the top of my organizational chart. If I try to move or nudge any one of these shapes, all of the shapes below it also move thus making it impossible to close the gap. If I try using the "change spacing" feature, it rearranges all of the shapes in my chart. Any advice would be greatley appreciated. Claudia The change spacing feature has several options, one of which is the Selected Shape. That should allow you to change the spacing for that shape only. So, i...

Help
My Regional Manager insists on things being perfect - need assistance with this problem. Working in Governemtn department - we have many users with unusal names and surnames - not common to standard dictionaries. My Rm wants to forward emails received with these peoples names in the original message - without outlook spell checking each of these names before sending. I have set up the email options under spelling - to ignore original message when forwarding - which it does but still spell checks the original message's recipients before sending. How do I set this up to exclude the n...

Distribution list help needed
We created a distribution list. Internal active directory users are able to send to the list. Internet e-mail senders are not able to send to the list. The mail is not bouncing back to the Internet e-mail users. The messages are just not getting to the inbox of the members of the distribution list. For example our domain is abc.net. The list we created is questions@abc.net. We have four users in the list. When a user logged into our Active Directory sends a mail to questions@abc.net the mail is successfully sent to the inboxes of all of the users in the list. When the e-mail ...

Formula Help #23
If I have a number in cell A1 like 5 and another number in cell A3 like 6 I want the number in A7 to show -1 and if cell A3 was 4 to read +1 and if the numbers are 2 away from A1 then the numbers in cell A7 would be -2 or +2 depending on the number in cell A3. All help is appreciated. Thanks Karl You must be kidding! =A1-A3 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Karl" <Karl@discussions.microsoft.com> wrote in message news:21FB7D9E-DC79-42...

Uploading Back to the Yahoo server...Please Help
Dear Member of this Help Forum; please help..please help me because i have lost all my important emails and i am so depressed...so sad....please Help....i HAVE SEARCHED THIS FROUM BUT NO ONE HAD THIS PROBLEM BEFORE.... My story and what i have done : I have a "Yahoo Small Business Account" with domain name and hosting, and 3 email address from that account. i used to use NO EMAIL CLIENT LIKE OUTLOOK at all and i used to save all my emails on yahoo servers and using yahoo normal email website to read, send and save all my emails...untill tonight! tonight i set up outlook 200...

Re: Can anyone help me with the IF function
Hello I'm trying to help my wife with simplifying her scheduling o employees. She uses 11 different time periods (1-11) some are worth the same amount of hours others are more or less. I can us seven functions to describe the period and the value of hours it is worth, but when I consolidate the functions i says the formula is invalid. I'm sure it can be fixed by one of you excel gurus! Here are the functions IF(B13<4,"7.75") IF(B13=4,"7.25") IF(B13=5,"6.25") IF(B13=6,"7.75") IF(B13=7,"6.75") IF(B13=8,"6.25") IF(B...

How to chart?
Need Help Charting Data -------------------------------------------------------------------------------- I have data in the following format: 10-05-04 395032 33757864 10-05-04 394656 33757864 10-05-04 394704 33757664 10-05-04 385544 33740816 10-05-04 431360 33795440 10-05-04 419656 33798832 10-05-04 403472 33768480 10-05-04 447864 33843624 ...

Help
Hi, i need to define a server side rule, which will copy attachments from received mails locally on PC/server. Any idea, scripts, anything? Tnx! Seems like ftp would be more appropriate than e-mail. But if you insist http://support.microsoft.com/search/default.aspx?spid=1773&query=event+sink+attachments&catalog=LCID%3D1033&pwt=false&title=false&kt=ALL&mdt=0&comm=1&ast=1&ast=2&ast=3&mode=a&x=18&y=11 HrVOjE wrote: > Hi, > > i need to define a server side rule, which will copy attachments from > received mails locally on PC/ser...

how to insert chart for imported data in a report?
plz reply soon if you know Please use the large white space under the subject to enter a detailed question. It also helps to read some past threads that might pertain to your question (whatever it is). -- Duane Hookom Microsoft Access MVP "varsha from pilibhit" wrote: > plz reply soon if you know ...

how do i create a macro to export a chart to powerpoint?
Can anyone give me any tips to create a macro to export data to powerpoint. When I try to record the sequence it falls over at the 'copy' stage. Hi, Have you seen Jon's page on the subject? http://peltiertech.com/Excel/XL_PPT.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "NPAT" <NPAT@discussions.microsoft.com> wrote in message news:BE9FBC41-25D4-4A27-8CBF-CF0F8E55D838@microsoft.com... > Can anyone give me any tips to create a macro to export data to > powerpoint. > When I try to record the sequence it falls over at ...

.pst file is maxed out - HELP
Apparently I have reached the maximum size of my outlook.pst file (see attached error message). I have tried deleting items but nothing I do seems to have any effect and I continue to get the attached error message. Therefore the eMail part of Outlook is disabled. Anyone got any pointers? XP Pro SP-2/Outlook 2003. Already using .pst format for database. Thanks, No image attached. Post a link, rather than an attachment. See http://www.slipstick.com/problems/repair2gbpst.htm=20 --=20 Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/o...

Deafault Save as??
I am trying to convert all my 2003 format project into 2007 version after an upgrade to MSP2007. I have tried to change the default version via 'Save as' and I have also changed the the option via Tools - Options - Save - Save Microsoft Office Project File As to Project (*Mpp) but this setting change always reverts back to the 2003 format? Can anyone please provide further suggestions? Or point me in the right direction? Many thanks, Hi John, I'm not sure I follow you completely. You open a file created in Project 2003 using Project 2007. What happens...

Save As DBF
Saving files as .dbf has been omitted from Excel 2007. My GIS staff use this quite extensively. What are other GIS users using to create the DBF files since 2007 can not make them? Access can make the DBF files, you just end up two stepping it. Niteschool wrote: > Saving files as .dbf has been omitted from Excel 2007. My GIS staff use this > quite extensively. What are other GIS users using to create the DBF files > since 2007 can not make them? Niteschool wrote: > Saving files as .dbf has been omitted from Excel 2007. My GIS staff use this > quite extensively. W...

Why does Excel ask to save when no changes were made?
This does not pertain to a new document. I open an existing document just to look at it, and when I go to close it, Excel asks if I want to save the document. No changes were made, so it shouldn't have to be saved. It's annoying. Mike One explanation could be that there is a time formula in a cell that has updated on openeing so the worksheet will have changed. -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''''s razor (Abbrev) &...