Thread: Bar Chart with two independent variables

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

No attachment. If too large try zipping it.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!