![]() |
Need to Graph Comparisons
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. |
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. |
All times are GMT +1. The time now is 09:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com