I've got a floating bar chart.

This is constructed using two series, the series I wish to plot, on top of
an invisible series (each invisible point being as high as the previous
invisible plus visible data point).

I've got one item (visible) which is negative. Rather than simply reducing
the height of my bar, excel has dropped it to the bottom of the chart. What
can I do?

Tom.

Should correct an error.

I said it was a floating bar chart - sorry - it's actually a waterfall chart.

Cheers.

"mr tom" wrote:

I've got a floating bar chart.

This is constructed using two series, the series I wish to plot, on top of
an invisible series (each invisible point being as high as the previous
invisible plus visible data point).

I've got one item (visible) which is negative. Rather than simply reducing
the height of my bar, excel has dropped it to the bottom of the chart. What
can I do?

Tom.

Perhaps you can follow this example, to help get the bars arranged properly:

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

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


"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
Should correct an error.

I said it was a floating bar chart - sorry - it's actually a waterfall
chart.

Cheers.

"mr tom" wrote:

I've got a floating bar chart.

This is constructed using two series, the series I wish to plot, on top
of
an invisible series (each invisible point being as high as the previous
invisible plus visible data point).

I've got one item (visible) which is negative. Rather than simply
reducing
the height of my bar, excel has dropped it to the bottom of the chart.
What
can I do?

Tom.

Thanks, Jon.

That's brill.

Think I'll take the lazy way out and download your addin.

:-)

Tom.

"Jon Peltier" wrote:

Perhaps you can follow this example, to help get the bars arranged properly:

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

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


"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
Should correct an error.

I said it was a floating bar chart - sorry - it's actually a waterfall
chart.

Cheers.

"mr tom" wrote:

I've got a floating bar chart.

This is constructed using two series, the series I wish to plot, on top
of
an invisible series (each invisible point being as high as the previous
invisible plus visible data point).

I've got one item (visible) which is negative. Rather than simply
reducing
the height of my bar, excel has dropped it to the bottom of the chart.
What
can I do?

Tom.