Home 
Search 
Today's Posts 
#1




waterfall chart ... once again ...
Hi There,
I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series .... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#2




Sige, check out http://www.addins.com/cascade_charts.htm
Bob Flanagan Macro Systems Delaware, U.S. 3022349857 http://www.addins.com Productivity addins and downloadable books on VB macros for Excel "SIGE" wrote in message om... Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series ... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#3




I'll look at this tonight unless you get a reply before then.
"SIGE" wrote: Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series .... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#4




I've got the following in my spreadsheet
BLANK RED GREEN Profit 2001 3.81 =10+B2 =IF($B2<0,$B2,0) =IF($B20,$B2,0) Trade P 5.71 =C2+E2D3 =IF($B3<0,$B3,0) =IF($B30,$B3,0) Prime Costs 1.2 =C3+E3D4 =IF($B4<0,$B4,0) =IF($B40,$B4,0) Conversion Costs 0.71 =C4+E4D5 =IF($B5<0,$B5,0) =IF($B50,$B5,0) A&P 1.41 =C5+E5D6 =IF($B6<0,$B6,0) =IF($B60,$B6,0) Other F&S 2.72 =C6+E6D7 =IF($B7<0,$B7,0) =IF($B70,$B7,0) G&A 1.12 =C7+E7D8 =IF($B8<0,$B8,0) =IF($B80,$B8,0) volume effect 15.27 =C8+E8D9 =IF($B9<0,$B9,0) =IF($B90,$B9,0) price effect 11.35 =C9+E9D10 =IF($B10<0,$B10,0) =IF($B100,$B10,0) Profit 2004 1.49 =C10+E10D11 =IF($B11<0,$B11,0) =IF($B110,$B11,0) I had to change the "starting point" for your first bar by adding 10 to it, otherwise, some of the other points would be less than zero and the chart wouldn't like it. Try plotting a stacked bar chart using the data in columns A, BLANK, RED and GREEN. You'll also need to use Rob Bovey's XY Chart Labeler to relabel the chart as the "base" Y value is not where you want it. I hope this helps. "SIGE" wrote in message om... Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series ... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#5




Hi Sige 
After dozens of requests from various readers of my site, I've added a page showing how to combine the "Waterfall Charts" and "Stacked Column Charts that Cross the X Axis" techniques: Waterfall Charts that Cross the X Axis http://peltiertech.com/Excel/Charts/...lcrossing.html The sample data is closely related to the data in your post.  Jon  Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ SIGE wrote: Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series .... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#6




Hi Jon,
Thanks a million!!! ... I am sure I won't be the only one to learn from it!!! Till the next chart, Sige Jon Peltier wrote in message ... Hi Sige  After dozens of requests from various readers of my site, I've added a page showing how to combine the "Waterfall Charts" and "Stacked Column Charts that Cross the X Axis" techniques: Waterfall Charts that Cross the X Axis http://peltiertech.com/Excel/Charts/...lcrossing.html The sample data is closely related to the data in your post.  Jon  Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ SIGE wrote: Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series .... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#7




Thank you very much Barb,
I tried it with success but still there was the starting point issue! Thanks a lot though! Sige "Barb Reinhardt" wrote in message ... I've got the following in my spreadsheet BLANK RED GREEN Profit 2001 3.81 =10+B2 =IF($B2<0,$B2,0) =IF($B20,$B2,0) Trade P 5.71 =C2+E2D3 =IF($B3<0,$B3,0) =IF($B30,$B3,0) Prime Costs 1.2 =C3+E3D4 =IF($B4<0,$B4,0) =IF($B40,$B4,0) Conversion Costs 0.71 =C4+E4D5 =IF($B5<0,$B5,0) =IF($B50,$B5,0) A&P 1.41 =C5+E5D6 =IF($B6<0,$B6,0) =IF($B60,$B6,0) Other F&S 2.72 =C6+E6D7 =IF($B7<0,$B7,0) =IF($B70,$B7,0) G&A 1.12 =C7+E7D8 =IF($B8<0,$B8,0) =IF($B80,$B8,0) volume effect 15.27 =C8+E8D9 =IF($B9<0,$B9,0) =IF($B90,$B9,0) price effect 11.35 =C9+E9D10 =IF($B10<0,$B10,0) =IF($B100,$B10,0) Profit 2004 1.49 =C10+E10D11 =IF($B11<0,$B11,0) =IF($B110,$B11,0) I had to change the "starting point" for your first bar by adding 10 to it, otherwise, some of the other points would be less than zero and the chart wouldn't like it. Try plotting a stacked bar chart using the data in columns A, BLANK, RED and GREEN. You'll also need to use Rob Bovey's XY Chart Labeler to relabel the chart as the "base" Y value is not where you want it. I hope this helps. "SIGE" wrote in message om... Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series ... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#8




Hi Bob,
Seems you have the addins which do what I need. And a lot more of them ... I'll check them out! Thx Thx Thx Sige "Bob Flanagan" wrote in message ... Sige, check out http://www.addins.com/cascade_charts.htm Bob Flanagan Macro Systems Delaware, U.S. 3022349857 http://www.addins.com Productivity addins and downloadable books on VB macros for Excel "SIGE" wrote in message om... Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series ... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#9




Once again, you can to the rescue
Hope all is well Joan "Jon Peltier" wrote: Hi Sige  After dozens of requests from various readers of my site, I've added a page showing how to combine the "Waterfall Charts" and "Stacked Column Charts that Cross the X Axis" techniques: Waterfall Charts that Cross the X Axis http://peltiertech.com/Excel/Charts/...lcrossing.html The sample data is closely related to the data in your post.  Jon  Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ SIGE wrote: Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series .... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
#10




Can't complain.
 Jon Joan NYC wrote: Once again, you can to the rescue Hope all is well Joan "Jon Peltier" wrote: Hi Sige  After dozens of requests from various readers of my site, I've added a page showing how to combine the "Waterfall Charts" and "Stacked Column Charts that Cross the X Axis" techniques: Waterfall Charts that Cross the X Axis http://peltiertech.com/Excel/Charts/...lcrossing.html The sample data is closely related to the data in your post.  Jon  Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ SIGE wrote: Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy series .... http://www.tusharmehta.com/excel/ch...fall/index.htm http://peltiertech.com/Excel/Charts/Waterfall.html http://peltiertech.com/Excel/Charts/Waterfall2.html http://peltiertech.com/Excel/Charts/...ies.html#Falls http://peltiertech.com/Excel/Charts/...ies.html#Fall2 http://peltiertech.com/Excel/Charts/...eAndBelow.html Jon, Tushar, Frank, ... Can you please put me on track? Amount Profit 2001 3,81 Trade P 5,71 Prime Costs 1,20 Conversion Costs 0,71 A&P 1,41 Other F&S 2,72 G&A 1,12 volume effect 15,27 price effect 11,35 Profit 2004 1,49 Starting with a negative value and crossing the xaxis is the killer... :o( Cheers Sige 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How do you create a cascade or waterfall chart  Charts and Charting in Excel  
Timeline Chart?  Charts and Charting in Excel  
negative waterfall chart  Charts and Charting in Excel  
Problem with xlusrgal.xls file  Charts and Charting in Excel  
pivot table multi line chart  Charts and Charting in Excel 