Multi Line Graph on Dashboard

Options

How do I arrange the data so that I can use the multi-line graph on the dashboard? I have 3 columns for sales (3 weeks out, 1 week out, 1 day prior) and 3 columns for projections (3 weeks out, 1 week out, 1 day prior). I'd like to have the dates on the bottom axis and the # units on the vertical axis and (2 different color lines or bars - ones for sales, one for projections).

Answers