Negatives in floating bar chart
 

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.

Negatives in floating bar chart
 

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.

Negatives in floating bar chart
 

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.

Negatives in floating bar chart
 

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.