Can I split data series in an excel chart?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
Multiple chart types on same chart 1
Percentages AND Value lables on Stacked Columns 1
How do I add category labels in a chart but keep series separate? 1
How to show 5 data series on one chart 3
presenting quarterly time series data 2
Stacking data from within a series within a bar chart 1
Line and Bar Graph in one 2

Top