LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
DEE DEE is offline
external usenet poster
 
Posts: 250
Default PLS HLP Waterfall doesn't display properly

I am following various instructions for creating a waterfall.

I have supplier names in column A, Values in column B and an additional
column C that will "disappear". I have followed the formula for column C so
that it ends up with a 0 value in the last cell, then created a stacked
column chart.

My bars don't seem to float - they are at the bottom of the chart.

I have tried different ways of rearranging, but to no avail, although I have
been at this for many, many hours and maybe am just exhausted.

I would like my largest segment to appear from 0, then the next largest
value to appear "stacked" above and to the right of this one, and so on.
Then, at the far right of the chart, I would like a column that represents
the total.

I also would like the value, plus the % of the whole, to appear above (and
outside) of each column.

Is this possible?? I have seen it on a hard copy, but am unsure as to how
to create it.

Here is my data:

Supplier Spent Invisible
Supplier1 149 304
Supplier2 140 164
Supplier3 75 89
Supplier4 23 66
Supplier5 13 53
Supplier6 11 42
Supplier7 42 0
Total 453

I am under the gun time-wise and any help would be incredibly appreciated.
--
Thanks!

Dee
 
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 I get the axis titles to display properly in ms graph 03? Sharkey Charts and Charting in Excel 1 March 5th 07 03:09 PM
Heartbroken: custom chart markers don't display properly in PowerPoint Del Cotter Charts and Charting in Excel 2 April 27th 06 04:15 AM
I have a problem to properly display the title of Value (Y) axis i Oak Charts and Charting in Excel 1 January 5th 06 04:16 PM
Cells formated as text do not always display properly Cass Excel Discussion (Misc queries) 2 July 23rd 05 01:59 AM
How to calculate/properly display significant figures ending in 0 A Zaffiro Excel Worksheet Functions 5 June 28th 05 08:36 PM


All times are GMT +1. The time now is 09:54 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"