Which type of graphic should I use?

Hi All,

I have got this problem:

I have a series of arrival and departure times which I want to put in a 
graphic in Excel.

My problem is that I can't find the right graphic for this data, it's 
not a line, bar or circle diagram.

Anyone got ideas how to visualise this data?

Thanks in advance,

Greetings,

Finn


0
finn1 (2)
5/21/2009 8:48:42 PM
excel.charting 18370 articles. 0 followers. Follow

3 Replies
467 Views

Similar Articles

[PageSpeed] 58

Finn wrote:
> Hi All,
> 
> I have got this problem:
> 
> I have a series of arrival and departure times which I want to put in a 
> graphic in Excel.
> 
> My problem is that I can't find the right graphic for this data, it's 
> not a line, bar or circle diagram.
> 
> Anyone got ideas how to visualise this data?
> 
> Thanks in advance,
> 
> Greetings,
> 
> Finn
> 
> 

Probably depends on what you are trying to show. An XY chart might work. 
I played with some random data, with arrivals and departures in separate 
series. With x-values of full date-time, and y-values of time-only, you 
would be able to see concentrations of arrivals/departures with respect 
to time and date.
0
smartin108 (170)
5/21/2009 11:43:32 PM
Hi,

Perhaps you are looking for a gantt chart
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

Cheers
Andy

-- 

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Finn" <finn@finnetje.nl> wrote in message 
news:J6jRl.10850$wz2.10307@newsfe30.ams2...
> Hi All,
>
> I have got this problem:
>
> I have a series of arrival and departure times which I want to put in a 
> graphic in Excel.
>
> My problem is that I can't find the right graphic for this data, it's not 
> a line, bar or circle diagram.
>
> Anyone got ideas how to visualise this data?
>
> Thanks in advance,
>
> Greetings,
>
> Finn
>
> 

0
andy9699 (3616)
5/22/2009 8:17:44 AM
>> Thanks in advance,
>>
>> Greetings,
>>
>> Finn
>>
>> 

Hi All & Andy,

This is where I was looking for!

Also was usefull the high/low/opening like for stockdata.

Thanks!

Finn


0
finn1 (2)
5/22/2009 8:48:17 AM
Reply:

Similar Artilces:

Using Access and Jasper Reports
First, I would like to thank all of you who have shared your knowledge with me over the past year. I have gone from not knowing the difference between an update query and an append query to being an expert novice :) Now for the question: I have a template in iReport (made by Jasper) that I need to fill with data from an Access table. The more I look at it the more I think this is way beyond my capability. My guess is it will require some type of VBA. Anyone have any suggestions on how to do this? Sorry to be so general, but right now all I know is Access has the data that I ne...

Exception when using Notify User alerts in custom view
Hello all! One of our users have found an error when he tried to setup notify user alerts from a custom list whenever there are changes on the list items included in a custom list view. Exception occured. (Exception from HRESULT: 0x80020009 (DIS_E_EXCEPTION)) Looking at the logs, we found the corresponding entry: Watson collection started: Windows SharePoint Services 3, ULSException12, w3wp.exe, 6.0.3790.3959, 45d6968e, onetutil.dll, 12.0.6327.5000, 48a405c4, NA, b51c6, c0000005, 837l Any clue to what have triggered this problem? Thanks! ...

Error code 2293 using windows live email
Hi I have recently installed windows live email and have Windows 7. I have a Access 2003 database of club members. I can no longer email members by clicking on a button. The button runs the following code: Private Sub btnEMail_Click() Dim vMessage As String On Error GoTo ErrorCode vMessage = Nz(DLookup("EMailSubject", "tblPersonal")) DoCmd.SendObject acSendNoObject, , , EMail, , , vMessage, , True AddHistoryRecord MembersNo, "E-Mail Sent :- (" & vMessage & ")" 'add histo...

Using name@domain.com and not name@domain.local
Hello, I have an AD that name is insae-bj.local. I have an Internet domain name that is insae-bj.com. I'm using exchange server 2003. I have for the moment my email adresses like name@insae-bj.local and I want to transform them on name@insae-bj.com . How can I do this. Thanks. Recipient Policy. -- Bharat Suneja MCSE, MCT www.zenprise.com blog: www.suneja.com/blog ----------------------------------------- "Derick AGUEY-ZINSOU @h2com.com>" <derickagu<nospam> wrote in message news:uDlsAbbLGHA.1028@TK2MSFTNGP11.phx.gbl... > Hello, > I have an AD that name ...

Creating a Rule Using "OR" instead of "AND" ???
Hello: I would like to create a rule that filter out SPAM using keywords either in the subject line or the e-mail body. Then having them deleted off the server before I even see them. For example, the rule should look something like this: Easy Money OR Sex OR Viagra OR Free Money I can't seem to find the OR option. When I tried to create this rule I got the below instead. Easy Money AND Sex AND Viagra AND Free Money Of course, since not all e-mails contain all of these keywords the rule didn't work. Can anyone please help? Thanks in advance! Spudy On Thu, 21 Jul 2005 22:52:...

jpg picture files - turn to graphics
Why does my jpg files change to a bitmap files once I pulbish the page to the web. The pictures look painted. covered on the FAQ - http://www.davidbartosik.com/faq.htm also in the future visit the web forum at microsoft.public.publisher.webdesign for your Publisher web issues. -- David Bartosik - MS MVP for Publisher help: www.davidbartosik.com enter to win Pub 2003: www.davidbartosik.com/giveaway.aspx "jenny" <anonymous@discussions.microsoft.com> wrote in message news:3b7d01c42a37$a5a442b0$a401280a@phx.gbl... > Why does my jpg files change to a bitmap files once I &...

highlight only complete row currently being used.
Is there a setting that will highlight a complete row if your cursor is in that row. I know the row number will be highlighted. Thanks There are methods using sheetchange events but the easiest method is to use Chip Pearson's RowLiner add-in. http://www.cpearson.com/excel/RowLiner.htm Just a note...........Rowliner won't work on protected sheets. If your sheet is protected you need event code. Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 13:25:01 -0700, 2MShad <2MShad@discussions.microsoft.com> wrote: >Is there a setting that will highlight a comp...

Use exprofre.exe with Citrix
I am migrating from exchange 5.5 to exchange 2003 and consolidating sites. For the users that have been moved cross administrative groups I need to run exprofre.exe when they first logon to fix their outlook profiles. This works fine for "fat" users but this doesn't work for "thin" users who work through citrix. If there is already one user working in outlook on the citrix server the exprofre.exe utility will not run because outlook is open... Does anyone of you know a solution to this? Thanks, Stijn In terminal type software issues such as these can be resolved ...

FRx Email Output of Spreadsheet using a Tree
I am trying to email an FRx report using the a Tree. The tree has 230 units and I am trying to export the file to a spreadsheet and email it as an attachment. I am getting an error 9060. I found a KB865164 but this is refering to FRx 6.5, I have the latest Service Packs installed for FRx 6.7 running Dynamics GP 10. If I email the report without the tree in the FRD format it comes through fine. Is there a limitation on how many worksheet can be created in an export or in one workbook? I have researched and can't find an answer to this.. Can I restirct with worksheets a user can vi...

page errors when using crm
hi! everytime i use crm in some computers i can't navigate, i open it, go to sales, and when i try to get back to the principal page, the explorer says the web page has errors: Line:69 Car:4 Error:access denied code: 0 url: http://server01/bar_bottom.aspx?startPage=home any ideas? thanks There is a fix you can get from Microsoft for this error. You should still be able to use the GoTo(navigation) from the main tool bar. Brett "Novapol" wrote: > hi! > > everytime i use crm in some computers i can't navigate, i open it, go to > sales, and when i try to ...

Using a different account to reply
Hi people, I run a web site and have it set up with 3 different E-mail accounts. Each account is forwarded to my ISP E-mail account. In Outlook Express I had a rule set up that would check all incoing mail for "Send to" and use that information to store each E-mail in a separate folder to keep everything organized. If I replied to an E-mail then the default mail account was used for my reply which was in my case my ISP account, but I always had the option to change it to any of my 3 web host E-mail accounts. I don't have that option in Outlook. It always forces me to use ...

Can i use a formula in the excel chart wizard?
I am creating a coursework in which i have to analyse a lot of data in the spreadsheet. it is already cluttered with columns and i dont want to add extra columns to add to the clutter. i was wondering whether there is a way to plot absolute values of a column without changing the actual values in the column or creating a new column using ABS() function. Thanx You can't use formulas in the reference boxes in the chart wizard. You can only use range references or defined names. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3...

Use Tax schedule
We have a new GP 9.0 client who needs to track the use tax on purchases they make out of state. They have to remit the use tax to the state of Florida. We set up a new tax detail and schedule, but it isn't working as we'd hoped. For instance, if we have a purchase of $100 to vendor ABC, we have to pay the vendor $100 and we have to pay FL $7.00 (7% tax rate). So ideally we'd like our purchases account to total $107, have Trade A/P show $100 to vendor ABC and vendor FL to show a liability of $7.00. What is happening is that when we select the tax schedule, it increases t...

SUMIF using two columns in both Range and Criteria
I have a speadsheet with columns as under: Account Code Department Amount ------------ ---------- ------ 7000 12 �100 7050 5 �250 There are a couple of hundred rows with different account numbers and a variety of Department numbers. Is there a way I can use SUMIF to summarize the amounts by Code AND Department? In other words I want to sum ALL the amounts with Code 7000 and Dept 12 etc. Thanks! =SUMPRODUCT(--(A1:A20&B1:B20="700012"),C1:C20) -- HTH Bob Phillips "Gordon" <go...

Migrating data using DMF into custom entity
Hi, I have 3 custom entities to migrate in addition to a few system entities (accounts, contacts, tasks...). My custom entities are join to system entities. I wanted to migrate data using the DMF but I believe the data migration framework doesn't deal with custom entity. How can I migrate my data? Is it possible to change the DMF manually easily so I can insert my data? Can I use a dts package for these 3 additional tables? Do I have to develop something with the sdk from scratch? I can't understand why the DMF is not dealing with this custom entities... The CRM has all in the inf...

Bank Transfers Carry Default Trx Type of Interest Income?
All of our transactions entered using the Bank Transfer Entry window display in SmartList with a CM Trx Type of Interest Income. Is there a setting somewhere that controls this? -- Pete P. Interest income? Which SmartList are you looking at? Bank Transfers go from one bank account to another so they should use the cash accounts assigned to the Checkbook ID. The cash account is a required field when you set up the checkbook. What account is set on the Checkbook? "Pete Pillitteri" wrote: > All of our transactions entered using the Bank Transfer Entry w...

Toolbar disappears at top of page using Excel 2000
Oftentimes when I minimize Excel and then maximize, I lose the toolbar along the top (the one with File, Edit, as well as my icons). I have never been able to get these back once they have disappeared, without shutting Excel down altogether. After I reopen Excel they are there, and everything seems to be fine, until I minimize again. Thanks! ...

SUMPRODUCT Using Unary on Filtered Range
I have a filtered range which l sum using the SUBTOTAL(9, A1:A100 formula. It allows me to sum the filtered range without bringing i the data that is not included in the filtered range. I want to do SUMPRODUCT on this filtered range. Normally I would use the followin SUMPRODUCT(A1:A100, B1:B100). However this will not work on a filtere range. How can I do this in one formula without creating a ne column? Thank -- Message posted from http://www.ExcelForum.com Hi try SUMPRODUCT(A1:A100, B1:B100,SUTOTAL(3,OFFSET($A$1,ROW($A$1:$A$100)-1,0))) -- Regards Frank Kabel Frankfurt, Germany &...

SOP Posting "locking" when used with Analytical Accounting
My Client upgraded to Dynamics GP 10.00.1400 from Dynamics GP 10.00.1328 on Jan 7, 2010. Since then, whenever some tries to post a SOP Invoice with AA information attached, the system appears to lock up not only for that user, but for any other user using Dynamics GP. Not other process seems to be affected from the update and I have contacted microsoft regarding the issue (they are looking at it), I was wondering if anybody else was coming across the same issue and if they were able to resolve it? -- Business Analyst ...

Using a query as base for report
Hello, I have created a table where I run a query picking the columns I want in the query. From the query, I create a report. My question is this: Whenever I open the report, I want it to show only the open items. Example: My query has 10 columns, when ALL the fields are populated, the record is complete and does not need to be in the report (i.e. open items report). If the 10 fields are NOT all completed, it's still considered opened and will be on the report when it is run. I think I'm thinking too much about it and making it sound harder to myself. Can you please...

Investment type #2
Is it possible to change the investment type of a security? Not directly. But see this: http://umpmfaq.info/faqdb.php?q=81 -- Glyn Simpson, Microsoft MVP - Money Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny for UK tips and fixes for MS Money. To send Microsoft your wishes or suggestions, use http://register.microsoft.com/mswish/suggestion.asp or email mnyukwsh@microsoft.com especially if it's a UK specific wish. I do not respond to any unsolicited email regarding Money "Don" <anonymous@discussions.microsoft.com> wrote in message news:49a801c42bfa...

use publisher template in word
I have designed stationary in publisher and would like to use it in word- ex. open the file and type my letter using word then print the whole page thus printing letterhead and words at the same time. Save it as an image, in Word, view, header and footer, insert the image into the header. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "lee" <lee@discussions.microsoft.com> wrote in message news:E7D19070-11BF-44F3-BA45-84FAFE0ECB95@microsoft.com... >I have designed stationary in publisher and would like to use it ...

Spot Color, Word Art, Autoshapes
I designed a project using PUBLISHER 2002. It came out great. However, when I save for pre-press SPOT COLOR (PANTONE), all the WORD ART graphics, and AUTOSHAPES turn GREY. The graphics that turn grey were all FILLED with a cloud graphic(.bmp) that was included with the program. I recolored the graphic using the FORMAT PICTURE>RECOLOR option to the PANTONE as I was advised by my printer. I also selected COLOR PRINTING>SPOT COLOR prior to saving. I also tried it by setting COLOR PRINTING>SPOT COLOR and selecting the PANTONE prior to designing the document. I am about to...

Reduction of data points used for a chart
I have exported a large number of data points from a chromatography data collection program into Excell. I have about 12000 x,y points. (Time versus milliVolts How can I reduce the amount of data points before making a chart? I would like, for example, to use only every tenth point for the chart. Ole - Suppose your data is in column C, starting in C2. In D2, put this formula =OFFSET(C$2,(ROW()-1)*10-1,0) And drag it down as far as you need. This puts the 10th, 20th, etc, points into column D. If you're plotting X-Y data, you need to do this for both X and Y. Use this new data for the...

using new List<String>();
Hello, I wonder do I create a memory leak by using private void myFunc() { List<String> joblist = new List<string>(); // ... add a alot of string into the joblist } and then call myFunc "repeatedly" from the main program It feels like I should return the memory somehow, but how? // Anders -- English is not my first language so any error, insults or strangeness has happend during the translation. Please correct my English so that I may become better at it! On 5/26/2010 11:02, Anders Eriksson wrote: > Hello, > > I wonder do I crea...