Creating a line chart for many series

Question

I have data in my sheet as shown below:

Day Area AVG(Time) ----------------------------- 2013-07-01 LINE1 49.703432 2013-07-02 LINE1 38.119913 2013-07-03 LINE1 30.6651 2013-07-04 LINE1 61.163277 2013-07-05 LINE1 29.757895 2013-07-01 LINE2 214.900325 2013-07-02 LINE2 185.053037 2013-07-03 LINE2 81.827013 2013-07-04 LINE2 72.822807 2013-07-05 LINE2 124.351707 [...] 

LINE up to 20, days is up to 60. I would like to create a chart in which the X axis is days , the Y axis numbers and for each LINE Excel will draw one line with dots. I tried several types of charts, but still nothing presentable.

Answer 1

Select ColumnsA: C, Insert> Tables - PivotTable, PivotChart and select New Worksheet or Existing Worksheet. Drag Day to the axis (category), Area fields to the legend (series) and AVG(Time) fields to Σ values. If necessary, left-click on the contents of Σ Values ​​and select "Field Field Settings" and "Sum".

Right-click on the chart (presumably on the pie) and select the selection chart using Change chart type ...

To remove links to (blank) , restrict input to PT by clicking on PT and PivotTable Tools> Options> Data, Change Data Source.