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

You need to rearrange your data:

http://peltiertech.com/WordPress/200...column-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Graham Tritton" wrote in message
...
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