I am trying to recreate the attached chart. My data is a set of records that contain two key identifiers: "Lost time" and "Injury Incident". The selection options for both of these fields is Yes, No, Unknown, entered by users of a system. My dataset is pulling from the system where *either* one of these identifiers is YES. So in my data I have records where ‘Lost time’ may be YES or ‘Incident’ may be YES. I also have the accident month and year for identifying when it occurred. For example:
Record # Accident Year Accident Month Lost time Injury Incident
RC0003233 2007 08 Yes Unknown
RC0003232 2007 12 Yes Unknown
RC0006323 2009 09 No Yes
RC0006827 2008 01 Unknown Yes
RC0006823 2009 08 No Yes
CCH7801-WC 2007 01 Unknown Yes
RC0006876 2008 02 Unknown Yes
As you can see in the attached desired output, I am trying to get a bar chart that counts the number of ‘Lost time’ records OR ‘Incident’ records, but on the same chart. The desired output should display in the same month, a count of records where Lost Time = Y and independently where Indicants = Y. Using pivot tables I am able to do this for each variable (‘Lost time’ or ‘Incident’) independently using the built in filter tool, but not on the same chart. I am thinking I need some sort of count if function, but am pretty lost at this point.
Also posted here: http://www.mrexcel.com/forum/showthread.php?t=432105
Bookmarks