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
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