Help!

negative values in a waterfall chart
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Charting RSS
Next:  Clicking on chart does not bring to foreground  
Author Message
MelissaF
External


Since: Aug 09, 2007
Posts: 1
PostPosted: Thu Aug 09, 2007 2:02 pm    Post subject: negative values in a waterfall chart
Archived from groups: microsoft>public>excel>charting (more info?)
How do you display negative values in a waterfall chart? Everytime I have a
negative value in my data, the bar disappears off the chart.
Back to top
Jon Peltier
External


Since: Mar 19, 2004
Posts: 1948
PostPosted: Thu Aug 09, 2007 5:11 pm    Post subject: Re: negative values in a waterfall chart [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Check this sample page:

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

The utility below accommodates positive and negative values:

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

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


"MelissaF" <MelissaF.TakeThisOut@discussions.microsoft.com> wrote in message
news:AAFCACE6-BBAD-48A1-8CF6-1C44C146DBA2@microsoft.com...
> How do you display negative values in a waterfall chart? Everytime I have
> a
> negative value in my data, the bar disappears off the chart.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Charting All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum