Need to Graph Comparisons

[tshirk]

I know this is going to sound really basic and I apologize in advance.
Monthly, I track activity on our hotline, by facility and by issue type. I
have a stacking bar graph that I generate. The names of the issues are on the
left side, with the facilities across the top. This results in the issues
stacked for each facility. I need to know how to generate a graph that will
show comparisons for month to month by facility, quarter to quarter, etc.

Do I do duplicate sets of data by month and if so, how can I graph them to
compare them? I hope this makes sense and thank you for your help.

 

[Luke M]

You could try using a stacked-cluster chart. See Jon Peltier's site for more
info:

http://peltiertech.com/WordPress/clustered-stacked-column-charts/