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
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
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:
- How to count tickets by month
- How to count names in excel - Guide
- Month calculator - Download - Calculators
- Count occurrences in excel - Guide
- How much is netflix a month - Guide
- Ps plus free games this month - Guide
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
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.