How to count tickets by month

Closed
ars - Feb 8, 2010 at 02:49 PM
rickster Posts 111 Registration date Thursday February 4, 2010 Status Member Last seen September 11, 2013 - Feb 8, 2010 at 06:52 PM
Hello,

An excel file containts Ticket Id and Date for last four years.

How can I draw a graph showing tickets by month for last years?

e.g. Jan. 2006- 200
Feb 2006- 500

Thanks.

Arun
Related:

1 response

rickster Posts 111 Registration date Thursday February 4, 2010 Status Member Last seen September 11, 2013 10
Feb 8, 2010 at 06:52 PM
hi! go to the filter in the top right hand corner, and select the custom filter for the month you require then copy all the data in to anothersheet and use the bar chart.
0