Hi, I have data that contains errors that occurred on certain days. There are three different errors, one of them is not shown in the test data. The other two are. I have to create a pivot chart that will graph the date on the x axis and the amount of errors for each error on the y axis. Each error will then have its own line on the graph showing its occurrences for the day. Here is the code and the test data that I currently have below:
Sub Button3_Click()
With ThisWorkbook.ActiveSheet.Range("C1:C" & Range("A" & Rows.Count).End(xlUp).Row)
    .Formula = "=If(A1<>"""",MID(A1,1,(FIND("" "",A1))),"""")"
    .Value = .Value
    .NumberFormat = "mm/dd/yyyy"
End With
With ThisWorkbook.ActiveSheet.Range("D1:D" & Range("A" & Rows.Count).End(xlUp).Row)
    .Formula = "=If(A1<>"""",MID(A1,1,(FIND("" "",A1))),"""")"
    .Value = .Value
    .NumberFormat = "mm/dd/yyyy"
End With
End Sub
I created two columns for the date in order to help with graphing, so when I manually create a pivot chart I use one date column for legend fields, and another for axis fields, then I use the errors column for the values. This creates the graph that I am looking for.

5/23/14 12:19:05:439 EDT WebSphere error: WSVR0605W
5/23/14 12:19:05:467 EDT WebSphere error: WSVR0605W
5/23/14 12:25:05:512 EDT WebSphere error: WSVR0605W
5/23/14 12:25:05:517 EDT WebSphere error: WSVR0605W
6/4/14 8:47:27:566 EDT WebSphere error: WSVR0605W
6/4/14 8:47:27:573 EDT WebSphere error: WSVR0605W
5/28/14 15:06:39:662 EDT WebSphere error: WSVR0605W
5/28/14 15:06:39:682 EDT WebSphere error: WSVR0605W
5/28/14 15:06:39:698 EDT WebSphere error: WSVR0605W
5/28/14 15:06:39:718 EDT WebSphere error: WSVR0605W
5/28/14 15:06:39:732 EDT WebSphere error: WSVR0605W
5/28/14 15:09:39:748 EDT WebSphere error: WSVR0605W
5/28/14 15:09:39:772 EDT WebSphere error: WSVR0605W
5/28/14 15:09:39:884 EDT High Thread Count
5/28/14 15:09:39:884 EDT WebSphere error: WSVR0605W
5/31/14 10:22:33:791 EDT WebSphere error: WSVR0605W
5/31/14 10:22:33:801 EDT WebSphere error: WSVR0605W
5/31/14 10:22:33:809 EDT WebSphere error: WSVR0605W
5/31/14 10:22:33:813 EDT WebSphere error: WSVR0605W
5/31/14 10:22:33:820 EDT WebSphere error: WSVR0605W
5/31/14 10:25:33:831 EDT WebSphere error: WSVR0605W
5/13/14 20:31:07:107 EDT WebSphere error: WSVR0605W
5/13/14 20:31:07:111 EDT WebSphere error: WSVR0605W
5/13/14 20:31:07:115 EDT WebSphere error: WSVR0605W
5/14/14 14:34:10:282 EDT WebSphere error: WSVR0605W
5/14/14 14:34:10:288 EDT WebSphere error: WSVR0605W
5/14/14 14:34:10:293 EDT WebSphere error: WSVR0605W
5/14/14 16:31:10:582 EDT WebSphere error: WSVR0605W
5/27/14 12:36:46:362 EDT WebSphere error: WSVR0605W
5/27/14 12:36:46:368 EDT WebSphere error: WSVR0605W
5/30/14 10:50:19:624 EDT WebSphere error: WSVR0605W
5/30/14 10:50:19:660 EDT WebSphere error: WSVR0605W
5/30/14 10:50:19:732 EDT WebSphere error: WSVR0605W
5/30/14 10:50:19:739 EDT WebSphere error: WSVR0605W
6/5/14 11:08:43:908 EDT WebSphere error: WSVR0605W
6/5/14 11:08:43:930 EDT WebSphere error: WSVR0605W
6/5/14 11:08:43:950 EDT WebSphere error: WSVR0605W
6/5/14 11:08:43:988 EDT WebSphere error: WSVR0605W
6/5/14 11:08:44:001 EDT WebSphere error: WSVR0605W
6/5/14 11:08:44:033 EDT WebSphere error: WSVR0605W
6/5/14 11:11:44:065 EDT WebSphere error: WSVR0605W
6/5/14 11:11:44:082 EDT High Thread Count
6/5/14 11:11:44:082 EDT WebSphere error: WSVR0605W
6/5/14 11:11:44:089 EDT High Thread Count
6/5/14 11:11:44:089 EDT WebSphere error: WSVR0605W
6/5/14 11:11:44:108 EDT High Thread Count
6/5/14 11:11:44:108 EDT WebSphere error: WSVR0605W
6/5/14 11:11:44:148 EDT High Thread Count
6/5/14 11:11:44:148 EDT WebSphere error: WSVR0605W
6/5/14 11:11:44:168 EDT High Thread Count
6/5/14 11:11:44:168 EDT WebSphere error: WSVR0605W
6/5/14 11:14:44:192 EDT High Thread Count
6/5/14 11:14:44:192 EDT WebSphere error: WSVR0605W
6/5/14 11:14:44:274 EDT High Thread Count
6/5/14 11:14:44:274 EDT WebSphere error: WSVR0605W
6/5/14 11:14:44:368 EDT High Thread Count
6/5/14 11:14:44:368 EDT WebSphere error: WSVR0605W
6/5/14 11:14:44:417 EDT High Thread Count
6/5/14 11:14:44:417 EDT WebSphere error: WSVR0605W
6/5/14 11:17:44:460 EDT High Thread Count
6/5/14 11:17:44:460 EDT WebSphere error: WSVR0605W
6/5/14 11:17:44:480 EDT High Thread Count
6/5/14 11:17:44:480 EDT WebSphere error: WSVR0605W
6/5/14 11:29:44:541 EDT High Thread Count
6/5/14 11:29:44:541 EDT WebSphere error: WSVR0605W
6/5/14 11:29:44:550 EDT High Thread Count
6/5/14 11:29:44:550 EDT WebSphere error: WSVR0605W
6/5/14 11:29:44:570 EDT High Thread Count
6/5/14 11:29:44:570 EDT WebSphere error: WSVR0605W
6/5/14 11:29:44:593 EDT High Thread Count
6/5/14 11:29:44:593 EDT WebSphere error: WSVR0605W
6/5/14 11:29:44:615 EDT High Thread Count
6/5/14 11:29:44:615 EDT WebSphere error: WSVR0605W
6/5/14 11:32:44:652 EDT High Thread Count
6/5/14 11:32:44:652 EDT WebSphere error: WSVR0605W