Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Nested graph
I am trying to create a column graph with three variables: month (jan, feb
.... dec), site (site 1, site 2) and action (action 1, action 2). I want the month on the X axis and have two columns, one with action 1 & 2 for site 1, and the other with action 1 & 2 for site two. I tried the "Stacked Column" feature which is close to what I want but not quite. I want jan data for site 1 & 2 to be right next to each other (no space). I also want to differentiate the colors/patterns for the sites: I want each site to have its own color. Right now I have two colors: one for action 1 and the other for action 2. Does anyone know how to do that with Excel 2003? Thanks so much! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Nested graph
Hi,
For work around to create cluster+stack see, http://peltiertech.com/WordPress/clu...column-charts/ Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Catherine" wrote in message ... I am trying to create a column graph with three variables: month (jan, feb ... dec), site (site 1, site 2) and action (action 1, action 2). I want the month on the X axis and have two columns, one with action 1 & 2 for site 1, and the other with action 1 & 2 for site two. I tried the "Stacked Column" feature which is close to what I want but not quite. I want jan data for site 1 & 2 to be right next to each other (no space). I also want to differentiate the colors/patterns for the sites: I want each site to have its own color. Right now I have two colors: one for action 1 and the other for action 2. Does anyone know how to do that with Excel 2003? Thanks so much! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Nested graph
Thank you for the info. I am however still stumped because I work for the
military and they won't let me download any charts. I can't even watch the tutorials because I can't have QuickTime either. Do you have any other solutions? Thank you. Catherine "Andy Pope" wrote: Hi, For work around to create cluster+stack see, http://peltiertech.com/WordPress/clu...column-charts/ Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Catherine" wrote in message ... I am trying to create a column graph with three variables: month (jan, feb ... dec), site (site 1, site 2) and action (action 1, action 2). I want the month on the X axis and have two columns, one with action 1 & 2 for site 1, and the other with action 1 & 2 for site two. I tried the "Stacked Column" feature which is close to what I want but not quite. I want jan data for site 1 & 2 to be right next to each other (no space). I also want to differentiate the colors/patterns for the sites: I want each site to have its own color. Right now I have two colors: one for action 1 and the other for action 2. Does anyone know how to do that with Excel 2003? Thanks so much! . |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Nested graph
I found out how to do it using http://people.stfx.ca/bliengme/. Thank you for
your help! "Catherine" wrote: Thank you for the info. I am however still stumped because I work for the military and they won't let me download any charts. I can't even watch the tutorials because I can't have QuickTime either. Do you have any other solutions? Thank you. Catherine "Andy Pope" wrote: Hi, For work around to create cluster+stack see, http://peltiertech.com/WordPress/clu...column-charts/ Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Catherine" wrote in message ... I am trying to create a column graph with three variables: month (jan, feb ... dec), site (site 1, site 2) and action (action 1, action 2). I want the month on the X axis and have two columns, one with action 1 & 2 for site 1, and the other with action 1 & 2 for site two. I tried the "Stacked Column" feature which is close to what I want but not quite. I want jan data for site 1 & 2 to be right next to each other (no space). I also want to differentiate the colors/patterns for the sites: I want each site to have its own color. Right now I have two colors: one for action 1 and the other for action 2. Does anyone know how to do that with Excel 2003? Thanks so much! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
How do I plot multiple series on one graph? - test-graph.xls (0/1) | Charts and Charting in Excel | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel |