View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Need to Graph Comparisons

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

http://peltiertech.com/WordPress/clu...column-charts/
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tshirk" wrote:

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.