Stacked Column Chart Over x axis

[pwchad01]

How do I get a stacked column to go over x axis the way I want it to?

I'm looking to show the breakdown of sales into the costs - cost of goods, shipping, rent, staff costs, etc.. with profit the balance to add upto 100%.
This works fine in a stacked column where there is a profit, however, I have a year when there was a loss, the costs become greater than 100% - but I still want to show 100% above the x axis, with the remainder below.
Using the the data in a stacked chart, the year with a loss shows less than 100% above the x axis.

I've no doubt this has already been answered - but I couldn't find an answer in previous postings (I've previously found waterfall chart help).

Cheers,
Paul

 

[Gerald Higgins]

Hi, welcome to the board.

I'm sure you can do this, if you set up your data correctly, so that there is a negative value for the data relating to a loss.

If you post more details, we might be able to help you more specifically.

 

[pwchad01]

Thanks for coming back to me Gerald - I managed to put something together (not slick, but did the job).
Found a link on google from an MVP that helped http://peltiertech.com/Excel/Charts/StackedColumnsAboveAndBelow.html
Cheers,
Paul