Adding labels to a waterfall BAR chart

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?

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?

For ideas on placing the XY points, look at the example of Dot Plots he

http://peltiertech.com/Excel/Charts/DotPlot.html

or the example of advanced Gantt charts with labels he

http://peltiertech.com/Excel/Charts/GanttChart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
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?

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?

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?