ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Need to Graph Comparisons (https://www.excelbanter.com/charts-charting-excel/243006-need-graph-comparisons.html)

tshirk

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.

Luke M

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