Hi Sarah,

Thanks for making your final solution available to view. Nice job on
that chart.

By the way as all your bars are on the primary axis you could change the
line series to an xy-scatter series. remove the primary value axis and
display the secondary value axis instead. You can then format the axis
using built-in dialogs.

Cheers
Andy

sarah o. wrote:
Just in case anyone else finds it useful, here's the result:
http://epdc.org/junk/testpyramid.xls.

Sarah

Andy Pope wrote:

Hi,

If you just need a single image could you not group the charts before
creating an image file?

How often do you have to produce these charts and much does the data
change? It is possible to construct the chart you want using a single
chart and multiple data series. But, and you knew there was a but coming
;) , The value scale is not dynamic. Even with VBA code it could be
complex. The hard part positioning the data label holding the scale value.

Cheers
Andy

sarah o. wrote:

Ah, I tried to use the Arbitrary Axis technique described he
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html, but it seems
that XY charts and bar charts cannot be combined. How frustrating,
since bar charts are so much like column charts, which can be combined
with XY charts.

I appreciate the lead, even if it didn't pan out. Any other ideas?

Thanks,
Sarah

sarah o. wrote:


Thanks--it looks like the "Arbitrary Axis Scale" is the bit that I'm
missing. I'll try this out soon.

Sarah


Bernard Liengme wrote:


Have a look at Jon's example
http://peltiertech.com/Excel/Charts/tornadochart.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info