MS Chart Help

Question

I am working with MSChart. I took the example code off of Patric Johansson tutorial about MSChart and trying to make mine do the same thing. Here is a piece of his code:

-------------------------------------------------------------
axMSChart.ChartData = new Object[5, 4] {
                {null,     "Computer A","ComputerB", "Computer C"},
                {"10:00 AM", 123131,      242142,      254353},
                {"10:01 AM", 113121,      171345,      205432},
                {"10:02 AM", 126323,      281876,      269743},
                {"10:03 AM", 199833,      242122,      283445}};

--------------------------------------------------------------

What I want to do is get my arrays in the above format.
My results from the array will be (these are examples)
 
12-Jul-2007,  10:00 am,  HGB, 10.5
12-Jul-2007,  10:00 am,  HCT, 31.0
12-Jul-2007,  11:00 am,  HGB, 12.0
12-Jul-2007,  11:00 am,  HCT, 36.0
13-Jul-2007,  12:00 am,  HGB, 12.5
13-Jul-2007,  12:00 am,  HCT, 37.0
15-Aug-2007, 11:15 am, HGB, 14.0
15-Aug-2007, 11:15 am, HCT, 42.1

...and so on. They can have different dates, times and results.

I want it to look like:

{null, "HGB","HCT"},
{12-Jul-2007, "10:00 AM", "10.5", "31.0"},
{12-Jul-2007, "11:00 AM", "12.0", "36.0"},
{13-Jul-2007, "12:00 AM", "12.5", "37.0"},
{15-Jul-2007, "11:15 AM", "14.0", "42.1"}};

What I am trying to achieve is a 3d bar chart with the date and time on the X-Axis, the result on the Y-Axis and the tests, HGB and HCT on the Z-Axis. I can't get it to work.  What happens now is:

Each test (hgb and hct) show up on a separate column with the date/time on the X-axis and the result shows up on the Y-Axis. I can't get a Z-Axis with the two tests on it.


My piece of code is below..
======================================

try
{
 SqlCommand cmd = new SqlCommand(
    "Select Count(*) " +
    "From LabDB " +
    "Where l.name in ('HGB', 'HCT') ",conn);

 int arraySize = Convert.ToInt32(cmd.ExecuteScalar());

 cmd.CommandText = "Select l.date as resultDate, " +
                           l.time as resultTime, " +
            itemname = case " +
            "when l.name = 'HGB' " +                             
                "then 'Hemoglobin' " +

            "when l.name = 'HCT' " +
                "then 'Hematocrit' " +
            "end, " +                                     
            "l.value as result " +
            "From LabDB " +
                    "Where l.name in ('HGB', 'HCT') ",conn);
            "Order by l.resultDate desc, itemname ";

SqlDataReader dr = cmd.ExecuteReader();

string [,] ptInfo = new string [arraySize, 4];
int i = 0;

if ( null != dr )
{
  while (dr.Read() & i < arraySize)
  {
    ptInfo[i, 0] = dr["itemname"].ToString();
    ptInfo[i, 1] = dr["resultDate"].ToString();
    ptInfo[i, 2] = dr["resultTime"].ToString();
    ptInfo[i, 3] = dr["result"].ToString();

    axMSChart1.ChartData = ptInfo;
    i += 1;
   }
   dr.Close();
}        
}
=================================================
Can anyone help?

Thanks,
Tony