# No expert and in need of guidance!

#### ijoeveer

##### New Member
Hello:
I have a difficult time taking data and visualizing as a chart but have the ability to articulate what I'm attempting to do. Hoping for some good advice.
I have a 5500 line column of data. In each line, is a date, and a time.
Each line represents a ticket.
I'd like to calculate an arrival pattern and represent it graphically.
7/1/2007 10:13 (is the format in which the data appears on each line)
UPDATE: I need to do a 30 min arrival pattern

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### gnrboyd

##### Well-known Member
If I understand what you are looking for, you have 5500 time entries that you need to put into a graph to show a pattern on when people arrive within a 30 minute period. I would summarize the times by minute into a table and then graph the table. I converted my times to text to avoid any decimal problems. The HTML program doesn't copy the actual graph that I did in my example but you can use the graph wizard on the summary table and it should be easy from there. If you'd prefer, send me a personal message with your email address and I will email you my example. Hope this helps.

(Note: The HTML program cut off my last couple of rows which is why my time quanties appear to be off by a couple)

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=10><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Book1</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=10><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=10><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value==COUNTIF(\$A\$2:\$A\$30,C2) selected>D2<OPTION value==COUNTIF(\$A\$2:\$A\$30,C3)>D3<OPTION value==COUNTIF(\$A\$2:\$A\$30,C4)>D4<OPTION value==COUNTIF(\$A\$2:\$A\$30,C5)>D5<OPTION value==COUNTIF(\$A\$2:\$A\$30,C6)>D6<OPTION value==COUNTIF(\$A\$2:\$A\$30,C7)>D7</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==COUNTIF(\$A\$2:\$A\$30,C2) name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">

Replies
3
Views
453
Replies
1
Views
360
Replies
3
Views
2K
Replies
0
Views
697
Replies
2
Views
423

1,190,781
Messages
5,982,873
Members
439,803
Latest member
sushilneupane

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back