Stacked column chart in duplicate

G

Graham Tritton

I am trying to create a stacked bar chart in Excel 2003 that is able to
compare sales actuals against target for 2 different channels. For each
period I want to have a stack for the actuals (2 data points) (Primary Value
Axis) and another stack superimposed (overlap 100%, larger gap) for targets
(secondary value axis). The axis will have the same scale paramater values
eg. min, max & major unit.

Data structure as per below.
Chnl metric Jan Feb Mar
Inbound Actual 10 20 30
Outbound Actual 50 50 50
Inbound Target 15 15 15
Outbound Target 75 35 35
 

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
Stacked Column Charts 2
Stacked Column Chart 3
Combo chart format- what is the best way to achieve this design? 1
stacked column chart 4
Removing 0 in Stacked Column Chart 1
Stacked Column Chart with gaps! 1
Trendline in Stacked Column Chart 2

Top