Even when you provide X values that match the bar values and a equi spaced Y
values?
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
Thanks Andy.
I've tried this and it doesn't seem to work as whilst my waterfall runs on
one axis, the scatter still insists on running perpendicular to it.
Cheers,
Tom.
"Andy Pope" wrote:
Hi,
Instead on Line series use an XY-scatter series. This will allow you to
control both the horizontal and vertical position of the labels.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
Chaps,
I've got a waterfall chart which is based on bars, not on columns.
I.e.
the
bars run from left to right.
This is fine until I try to add the labels, which using the Peltier
method
involves adding an invisible line series.
And here's where the problem arises. Excel only does line charts
horizontally, not vertically, so I can't put it onto my waterfall.
Anybody got any ideas?