Graph multiple series in Excel 1

[sankaku]

Hope someone can help...

I have a list of values that I pulled from a database that would look something like this:

1/1/2013 Ontario 10
1/2/2013 Ontario 14
1/1/2013 Alberta 8
1/2/2013 Alberta 12
etc

I've put filters on the data so that the user can select one or more dates.

Now, I'd like to set up a graph that illustrates the values. The x-axis would be the second column (province), the y-axis (series) would be the third column. But, I'd like the chart to create different series based on the date. In this case, 1/1/2013 would be one line and 1/2/2013 would be a second. If the user selects 3 dates, then there would be 3 lines.

I'm not able to get it to do this... any suggestions?

Thanks in advance.

 

[SkipVought]

hi,

You would need a separate column for each date.

So use a PivotTable/PivotChart. Should take about 15 seconds.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[sankaku]

Ah... of course. Guess I had a bit of a brain freeze.

Thank you.