Hi Mark,

Does this help?
http://www.andypope.info/ngs/ng3.htm

If not can you explain how you created the pyramid chart.

Cheers
Andy

Mark wrote:
Hi

I've created a pyramid chart and now wish to add two further data series
that I am attempting to display as lines running vertically to show a
comparator for each bar on my pyramid. It can be achieved by adding a
trendline but when adding additonal data changing to a line chart, the lines
are displayed horizontally on a secondary axis.

Does anyone know of a way of resolving this?

Thanks

--

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