Negatives in floating bar chart

[Guest]

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.

 

[Guest]

Should correct an error.

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

Cheers.

 

[Jon Peltier]

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

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

- Jon

 

[Guest]

Thanks, Jon.

That's brill.

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



Tom.