Sample Table Chart Wedding How To Create Complicated Excel Chart With Two Variables?

How to create complicated excel chart with two variables? - sample table chart wedding

My data are a series of documents that the two most important identifiers in "Lost Time" and "breach incident." The choices for these two fields are Yes, No, Unknown, entered by the user of a system. My record draws the net, * the * One of these identifiers is YES. So I save my data on the "lost time" to YES or "disturbance" could indeed be. I also identify the month of the year in accidents, and when it happened. For example:

The record of accidents, accidents, lost time incident more months
RC0003233 2007 08 Yes Unknown
RC0003232 2007 12 Yes Unknown
RC0006323 2009 09 No Yes
RC0006827 2008 01 Yes Unknown
RC0006823 2009 08 No Yes
CCH7801 WC 2007 01 Yes Unknown
RC0006876 2008 02 Yes Unknown

I'm trying to get a bar graph that the number of "Lost Time Incident records or counts" books, but on the same graph. Clear the desired resultlived in the same month a number of records lost in time and independent = S = Y. Indica or PivotTables'm able to do this for each variable ( "lost time" or "events") with the building regardless of the filtering tool, but not on the same graph. I think I need a certain type of account, if the function, but I'm pretty lost at this point.

Dataset and sample output: http://series11.net/images/New/Excel_Help_Samples.JPG