Looking to create a chart showing X axis a time of day in hours and Y showing the Day. Show the history of the program would be easy but have many sub application. Just not getting how to setup the chart to show the plots of when a ticket was created. Working with Excel 2010.
<table border="1" cellpadding="0" cellspacing="0" width="453"><colgroup><col width="140"></colgroup><colgroup><col width="161"></colgroup><colgroup><col width="81"></colgroup><colgroup><col width="71"></colgroup><tbody><tr height="20"><td height="20" width="140">Program
Name</td><td width="161">Application
Name</td><td width="81">Time</td><td width="71">Date</td></tr><tr height="20"><td height="20">Program 1</td><td>Program 1 - SubApp 2</td><td>1:00 AM</td><td>10/5/2011</td></tr><tr height="20"><td height="20">Program 1</td><td>Program 1 - SubApp 1</td><td>3:00 AM</td><td>10/11/2011</td></tr><tr height="20"><td height="20">Program 2</td><td>Program 2 - SubApp 4</td><td>1:00 PM</td><td>10/11/2011</td></tr><tr height="20"><td height="20">Program 3</td><td>Program 3 - SubApp 2</td><td>9:00 AM</td><td>10/17/2011</td></tr><tr height="20"><td height="20">Program 3</td><td>Program 3 - SubApp 1</td><td>1:00 PM</td><td>10/17/2011</td></tr><tr height="20"><td height="20">Program 4</td><td>Program 4 - SubApp 6</td><td>11:00 PM</td><td>10/17/2011</td></tr><tr height="20"><td height="20">Program 5</td><td>Program 5 - SubApp 7</td><td>9:00 PM</td><td>10/18/2011</td></tr><tr height="20"><td height="20">Program 6</td><td>Program 6 - SubApp 8</td><td>5:00 AM</td><td>10/19/2011</td></tr><tr height="20"><td height="20">Program 6</td><td>Program 6 - SubApp 2</td><td>12:00 PM</td><td>10/19/2011</td></tr><tr height="20"><td height="20">Program 6</td><td>Program 6 - SubApp 2</td><td>7:00 AM</td><td>10/21/2011</td></tr><tr height="20"><td>Program 1
</td><td>Program 1 - SubApp 2</td><td>11:00 AM</td><td>10/27/2011</td></tr><tr height="20"><td>Program 1</td><td>Program 1 - SubApp 3</td><td>6:00 PM</td><td>10/29/2011</td></tr><tr height="20"><td>Program 8</td><td>Program 8 - SubApp 2</td><td>6:00 AM</td><td>11/2/2011</td></tr><tr height="20"><td>Program 9</td><td>Program 9 - SubApp 4</td><td>7:00 AM</td><td>11/4/2011</td></tr><tr height="20"><td>Program 10</td><td>Program 10 - SubApp 1</td><td>10:00 PM</td><td>11/6/2011</td></tr><tr height="20"><td>Program 11</td><td>Program 11 - SubApp 7</td><td>11:00 PM</td><td>11/7/2011</td></tr><tr height="20"><td>Program 12</td><td>Program 12 - SubApp 3</td><td>2:00 PM</td><td>11/8/2011</td></tr><tr height="20"><td>Program 12</td><td>Program 12 - SubApp 3</td><td>4:00 AM</td><td>11/8/2011</td></tr><tr height="20"><td>Program 12</td><td>Program 12 - SubApp 9</td><td>12:00 PM</td><td>11/10/2011</td></tr> </tbody></table>
<table border="1" cellpadding="0" cellspacing="0" width="453"><colgroup><col width="140"></colgroup><colgroup><col width="161"></colgroup><colgroup><col width="81"></colgroup><colgroup><col width="71"></colgroup><tbody><tr height="20"><td height="20" width="140">Program
Name</td><td width="161">Application
Name</td><td width="81">Time</td><td width="71">Date</td></tr><tr height="20"><td height="20">Program 1</td><td>Program 1 - SubApp 2</td><td>1:00 AM</td><td>10/5/2011</td></tr><tr height="20"><td height="20">Program 1</td><td>Program 1 - SubApp 1</td><td>3:00 AM</td><td>10/11/2011</td></tr><tr height="20"><td height="20">Program 2</td><td>Program 2 - SubApp 4</td><td>1:00 PM</td><td>10/11/2011</td></tr><tr height="20"><td height="20">Program 3</td><td>Program 3 - SubApp 2</td><td>9:00 AM</td><td>10/17/2011</td></tr><tr height="20"><td height="20">Program 3</td><td>Program 3 - SubApp 1</td><td>1:00 PM</td><td>10/17/2011</td></tr><tr height="20"><td height="20">Program 4</td><td>Program 4 - SubApp 6</td><td>11:00 PM</td><td>10/17/2011</td></tr><tr height="20"><td height="20">Program 5</td><td>Program 5 - SubApp 7</td><td>9:00 PM</td><td>10/18/2011</td></tr><tr height="20"><td height="20">Program 6</td><td>Program 6 - SubApp 8</td><td>5:00 AM</td><td>10/19/2011</td></tr><tr height="20"><td height="20">Program 6</td><td>Program 6 - SubApp 2</td><td>12:00 PM</td><td>10/19/2011</td></tr><tr height="20"><td height="20">Program 6</td><td>Program 6 - SubApp 2</td><td>7:00 AM</td><td>10/21/2011</td></tr><tr height="20"><td>Program 1
</td><td>Program 1 - SubApp 2</td><td>11:00 AM</td><td>10/27/2011</td></tr><tr height="20"><td>Program 1</td><td>Program 1 - SubApp 3</td><td>6:00 PM</td><td>10/29/2011</td></tr><tr height="20"><td>Program 8</td><td>Program 8 - SubApp 2</td><td>6:00 AM</td><td>11/2/2011</td></tr><tr height="20"><td>Program 9</td><td>Program 9 - SubApp 4</td><td>7:00 AM</td><td>11/4/2011</td></tr><tr height="20"><td>Program 10</td><td>Program 10 - SubApp 1</td><td>10:00 PM</td><td>11/6/2011</td></tr><tr height="20"><td>Program 11</td><td>Program 11 - SubApp 7</td><td>11:00 PM</td><td>11/7/2011</td></tr><tr height="20"><td>Program 12</td><td>Program 12 - SubApp 3</td><td>2:00 PM</td><td>11/8/2011</td></tr><tr height="20"><td>Program 12</td><td>Program 12 - SubApp 3</td><td>4:00 AM</td><td>11/8/2011</td></tr><tr height="20"><td>Program 12</td><td>Program 12 - SubApp 9</td><td>12:00 PM</td><td>11/10/2011</td></tr> </tbody></table>