I have a row with random dates and I want to create a chart that shows how many occurrence’s happen per month. So if there were 30 dates within January 2014, jan 2014 would show 30, feb 2014 would show XX, march 2014 would show XX etc. this happens through multiple years so it would have to differentiate between jan 14 and jan 15 etc. Any ideas?
Excel's charts are not really built to do the data analysis. What we usually do is perform the analysis in the spreadsheet, then build the chart from the results of the analysis.
I would probably use the FREQUENCY() function for this analysis: https://support.office.com/en-us/art...7-fd9ea898fdb9
1) Add a column or row that will be your "bins" array. This will contain the first date of each month (1 Jan 2014, 1 feb 2014, and so on).
2) Select the output cells and enter the FREQUENCY() function. Note that this is an array function, so you select all the output cells and commit the function with ctrl-shift-enter
3) Add a chart to plot the resulting frequencies against the bins array.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks