I used to create a chart with one data series displayed as columns
(result data) with another series on the same chart displayed as a
line (budget data). I cannot find any way of doing this in Excel 2007,
anyone offer some help on this?
"Bone_pyro" <an...@ab1cs.com> wrote in message
news:1177948480.0...@u30g2000hsc.googlegroups.com...
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Bone_pyro" <an...@ab1cs.com> wrote in message
news:1177948480.0...@u30g2000hsc.googlegroups.com...
In excel 2007 I right click to change series chart type on the two series I want to stack, and doing this stacks all three of them. No order combination of right-click-changing seems to make a difference. I have even tried to make a 'ghost' 2nd y-axis for the 2 series I want to stack, but XL stacks all three regardsless. Any way around this? If I plot the third 'lone' series as a line, it works fine; i.e. the other two remain the stacked bar.
Very vexing!
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com