View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jamie Jamie is offline
external usenet poster
 
Posts: 191
Default Comparing data from 2 monthly periods in 1 chart

I am trying to compare 7 coloumns of data (Housing Advice Stats) from May to
Oct 06 to the same set of data taken in May to Oct 07.

Ideally I'd like to lay one over the top of the other so I can see the
differences from one year to the next ie, have 2006 as a column chart and
2007 as a line chart.

Any ideas how I do this? So far the only charts I have created have been a
mess!

Thanks.