How can I create a stacked bar graph that shows different sets of data?
So I have two sets of data that I would like to graph using a stacked chart. Data set 1 contains a number of actions that are divided by month, for example, the month of May has 5 actions and the month of June has 3. Data set 2 contains the same actions, however, in this set they are divided by source (e.g. deviations, compliance, other, etc.). I would my stacked graph to tell me how many actions in May are deviations, compliance, or other. How may I set up a formula so that I can display this data?
Thanks in advance,