Extracting Date Values to Display in Chart

[Andrew D]

I have the following Excel 2007 sheet that is updated on a daily basis with the new days data:


Date Call Type Volume

19/11/2012 Damage 2

19/11/2012 Door 2

19/11/2012 Failed 2

20/11/2012 Damage 3

20/11/2012 Door 3

20/11/2012 Failed 3

21/11/2012 Damage 1

21/11/2012 Door 4

21/11/2012 Failed 1


I hope to create a horizontal line chart that will chart the 3 different call type's (Damage,Door,Failed)volume by each consecutive date. Each additional date's data will be added below in the same format daily and the graph range updated.


Any advice on the simplest way to go about this?


Thanks,


Andrew

 

[Faseeh]

Hi Andrew D,


Please see this file, you can also try with Pivot Chart:


http://dl.dropbox.com/u/60644346/Chart.xlsx


Regards,