Create combination stacked bar and line chart in PPT 2003

[Michael Eyestone]

Hello, apologies as this is a fairly advanced question. I'm familiar with
custom chart types in PowerPont 2003 (actually, of course, MS Graph) but have
not been able to create a chart that combines stacked bars with a line (the
line would be on the secondary axis)

Anyone?

Thanks in advance,
Michael Eyestone
Tokyo, Japan

 

[Michael Eyestone]

Hello, apologies as this is a fairly advanced question. I'm familiar with
custom chart types in PowerPoint 2003 (actually, of course, MS Graph) but have
not been able to create a chart that combines stacked bars with a line (the
line would be on the secondary axis)

Anyone?

Thanks in advance,
Michael Eyestone
Tokyo, Japan

Actually, I worked it out! (Of course, I should have written "stacked
column" chart to conform to MS Graph nomenclature). What I did was start
with the built-in, Custom "Line - Column on 2 Axes" chart type, then use the
"overlap" and "spacing" options for each of the column series to superimpose
the various bars on top of each other, ensuring that the ordering worked so
that the taller bars were behind the shorter ones, creating the look of a
stacked bar chart. Of course, I had to add the bar values to each other to
make them "stack", but that wasn't much to complain about!

Cheers,
Michael