title: Time graph of non-numeric data
body: <p>I'm trying to draw a scatter-plot in Excel 2007, with times along the x-axis, and text values along the y-axis.  Since I can build numeric values for the y-axis, another possible way to look at this would be to change the labels along the y-axis to be text (instead of their default numeric values).</p>
  
  <p>My actual dataset looks something like this:</p>
  
  <pre><code>start, end, flag, value
  1:00am, 2:30am, 0, A
  2:30am, 7:00am, 3, D
  7:00am, 12:30pm, 2, C
  12:30pm, 4:00pm, 7, H
  </code></pre>
  
  <p>Generally, if I were to plot this, I would translate it to something like:</p>
  
  <pre><code>time, flag, value
  1:00am, 0, A
  2:30am, 0, A
  2:30am, 3, D
  7:00am, 3, D
  7:00am, 2, C
  12:30pm, 2, C
  12:30pm, 7, H
  4:00pm, 7, H
  </code></pre>
  
  <p>Then I would build a scatter-plot with the time column as the x-axis and the flag column as the y-axis.  However, I'd much rather have the value column provide the label on the y-axis.</p>
  
  <p>I can't seem to find a way to do this in Excel.  </p>
  
  <p>Am I missing something or is there another tool I should look into?</p>