Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.charting
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Yr to Yr comparisons cisse_5 Excel Discussion (Misc queries) 7 May 15th 09 06:10 PM
Sheet Comparisons. Jeff[_10_] Excel Worksheet Functions 1 February 18th 08 11:52 PM
Multiply IF AND OR comparisons Hannu Laine Excel Worksheet Functions 1 June 16th 07 10:14 PM
Can I add more than 2 comparisons to an IF statement?? joshua Excel Discussion (Misc queries) 3 July 27th 06 06:58 AM
string comparisons Ron Excel Discussion (Misc queries) 0 February 17th 05 05:02 PM


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"