Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I get the axis titles to display properly in ms graph 03? | Charts and Charting in Excel | |||
Heartbroken: custom chart markers don't display properly in PowerPoint | Charts and Charting in Excel | |||
I have a problem to properly display the title of Value (Y) axis i | Charts and Charting in Excel | |||
Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
How to calculate/properly display significant figures ending in 0 | Excel Worksheet Functions |