title: How do I achieve a multi-series line chart in Crystal Reports?
body: <p>This relates to my <a href="https://stackoverflow.com/questions/17667913/how-do-i-achieve-a-pivot-report-in-crystal-reports-for-visual-studio">How do I achieve a pivot report in Crystal Reports for Visual Studio?</a> The data is the same, but they want a line chart as well. </p>
  
  <p>So, my data is <code>{datetime}</code>, <code>{car-id}</code>. The X -axis of the chart must show the hour of {datetime}, the Y axis the number of cars that entered the park at that hour, and I must have seven data series, lines, one for each day of the week. So, e.g. the <code>x/y</code> point on the green line shows that on Wednesday, at hour <code>x</code>, <code>y</code> cars entered the car park.</p>
  
  <p>Common sense tells me that I can kludge this by transforming the data source so that each day has its own column in a table, a table like this:</p>
  
  <p>DateTime
  WeekDay
  CarCount</p>
  
  <p>Yet the Crystal line chart doesn't seem to support more than one column, so there must be a different and better way of doing this. The weekday is part of <code>{datetime}</code> after all.</p>
  
  <p>How can I achieve this chart? I am a rank amateur at charting, and Crystal's idiosyncrasies really aggravate my lack of skills and experience in this area.</p>