Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Yr to Yr comparisons | Excel Discussion (Misc queries) | |||
Sheet Comparisons. | Excel Worksheet Functions | |||
Multiply IF AND OR comparisons | Excel Worksheet Functions | |||
Can I add more than 2 comparisons to an IF statement?? | Excel Discussion (Misc queries) | |||
string comparisons | Excel Discussion (Misc queries) |