I use waterfall graphs in most of our presentations. I was trying to switch
it up a little bit and give the people who view the reports I create a little
different view of things. I know that negative values should not happen on a
pie chart, but at first it appeared to be the best representation of the
detail (earnings: profit or loss) that I was trying to show.

"Del Cotter" wrote:

On Tue, 6 Mar 2007, in microsoft.public.excel.charting,
Robert Burke said:

Has anyone encountered a problem in Microsoft Excel 2003 with pie charts
where negative values data labels show up with reverse brackets (i.e. )5( )?
I sent this spreadsheet that I am working on to my home computer and when I
opened it up in Microsoft Excel 2002 the negative number label appeared
correctly (i.e. (5) ). I know the ultimate idea of a pie chart is not to
have a negative number, but on my pie chart I am showing total earnings for
different areas.

I am open to other chart representations to show total earnings for multiple
(10 areas).

Have you considered a waterfall chart? This shows the positive
contributions, the negative ones, and the net total.

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

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.