View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
AlMorg AlMorg is offline
external usenet poster
 
Posts: 1
Default Can I split data series in an excel chart?

I am trying to create a comparative bar chart with year-on-year quarterly
sales figures for three different branches of a company. There are three
divisional figures and a subsequent total for each quarter of each of the
three years. The separate series need to be the years but each quarter total
needs to be visually split by the three divisions (sales quarters along the
x-axis, £ along the y-axis, 3 separate bars for each quarter each
representing a year and each split into 3 sections by division)

I can't work out how to do it or even if it is possible to split the series
in this way?

Thanks