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!