Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SIGE
 
Posts: n/a
Default 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.tushar-mehta.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 x-axis is the killer... :o(
Cheers Sige
  #2   Report Post  
Bob Flanagan
 
Posts: n/a
Default

Sige, check out http://www.add-ins.com/cascade_charts.htm

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins 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.tushar-mehta.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 x-axis is the killer...
:o(
Cheers Sige



  #3   Report Post  
Barb R.
 
Posts: n/a
Default

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.tushar-mehta.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 x-axis is the killer... :o(
Cheers Sige

  #4   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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+E2-D3 =IF($B3<0,-$B3,0) =IF($B30,$B3,0)
Prime Costs 1.2 =C3+E3-D4 =IF($B4<0,-$B4,0) =IF($B40,$B4,0)
Conversion Costs -0.71 =C4+E4-D5 =IF($B5<0,-$B5,0) =IF($B50,$B5,0)
A&P 1.41 =C5+E5-D6 =IF($B6<0,-$B6,0) =IF($B60,$B6,0)
Other F&S 2.72 =C6+E6-D7 =IF($B7<0,-$B7,0) =IF($B70,$B7,0)
G&A -1.12 =C7+E7-D8 =IF($B8<0,-$B8,0) =IF($B80,$B8,0)
volume effect -15.27 =C8+E8-D9 =IF($B9<0,-$B9,0) =IF($B90,$B9,0)
price effect 11.35 =C9+E9-D10 =IF($B10<0,-$B10,0)
=IF($B100,$B10,0)
Profit 2004 1.49 =C10+E10-D11 =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.tushar-mehta.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 x-axis is the killer...
:o(
Cheers Sige



  #5   Report Post  
Jon Peltier
 
Posts: n/a
Default

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.tushar-mehta.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 x-axis is the killer... :o(
Cheers Sige




  #6   Report Post  
SIGE
 
Posts: n/a
Default

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.tushar-mehta.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 x-axis is the killer... :o(
Cheers Sige

  #7   Report Post  
SIGE
 
Posts: n/a
Default

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+E2-D3 =IF($B3<0,-$B3,0) =IF($B30,$B3,0)
Prime Costs 1.2 =C3+E3-D4 =IF($B4<0,-$B4,0) =IF($B40,$B4,0)
Conversion Costs -0.71 =C4+E4-D5 =IF($B5<0,-$B5,0) =IF($B50,$B5,0)
A&P 1.41 =C5+E5-D6 =IF($B6<0,-$B6,0) =IF($B60,$B6,0)
Other F&S 2.72 =C6+E6-D7 =IF($B7<0,-$B7,0) =IF($B70,$B7,0)
G&A -1.12 =C7+E7-D8 =IF($B8<0,-$B8,0) =IF($B80,$B8,0)
volume effect -15.27 =C8+E8-D9 =IF($B9<0,-$B9,0) =IF($B90,$B9,0)
price effect 11.35 =C9+E9-D10 =IF($B10<0,-$B10,0)
=IF($B100,$B10,0)
Profit 2004 1.49 =C10+E10-D11 =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.tushar-mehta.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 x-axis is the killer...
:o(
Cheers Sige

  #8   Report Post  
SIGE
 
Posts: n/a
Default

Hi Bob,

Seems you have the add-ins 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.add-ins.com/cascade_charts.htm

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins 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.tushar-mehta.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 x-axis is the killer...
:o(
Cheers Sige

  #9   Report Post  
Joan NYC
 
Posts: n/a
Default

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.tushar-mehta.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 x-axis is the killer... :o(
Cheers Sige



  #10   Report Post  
Jon Peltier
 
Posts: n/a
Default

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.tushar-mehta.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 x-axis is the killer... :o(
Cheers Sige




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you create a cascade or waterfall chart Strategist Charts and Charting in Excel 3 October 9th 07 03:43 PM
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 10:20 PM
negative waterfall chart Pablo Charts and Charting in Excel 3 January 27th 05 10:30 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 06:54 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"