View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] daobrien@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to create a stacked, staggered column graph w/ 2 y axes

Hi everyone. I searched the forum and couldn't find any answers to
this. I'm trying to compare two years worth of data using the
following information (w/ Excel 2003):

Stacked: A vs B
Staggered: 2006 vs 2007
2 Axes: % of A to B 2006 vs % of A to B 2007


Anybody have a clue on how to do this? I can create a stacked graph of
2006-2007 data w/ a y axes for % of A to B; but it would make much
more sense if i could compare the years side by side rather than
linearly to look for seasonal trends. any ideas?