• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Visualize trade-off results

B

Bram

New Member
Hi there!


I have made a trade-off, evaluating various fuel sources on factors as weight, emissions, and so on. I'd like to present that in Excel/Powerpoint as a dynamic graph. At the first click, the first scores show, at the next, the second set of scores is added to these first. Animating all this shouldn't be a problem, but getting the figure right is. I have put most effort into stacked bar charts, but when the first score is -10 and the second is 3, the 'result' is not a bar that runs from 0 to -7, but one that stretches from +3 to -10.


Another possibility would be to show this in a set of line graphs, but that would make the slides quite messy. Do you know a method to achieve the above, or a valid alternative? Any help is much appreciated!
 
Hi Bram ,


I think what you want is probably best shown by waterfall charts :


http://peltiertech.com/WordPress/excel-waterfall-charts-bridge-charts/


The stacked chart basically 'builds' one series values on top of another ; so in your example , if one series value is 3 , and the other is -10 , then logically , you should have one bar going from 0 to 3 , and the other going from 3 to -7. A bar from 0 to 7 will lose information , since you will not see the +3 value at all.


If we go the other way , one bar should go from 0 to -10 , and the second bar should go from -10 to -7.


Either way , 0 to 7 is probably not the way to go.


Either of the two alternatives I have mentioned can be obtained by adding helper columns which get the required sums from the two series values , and then using the helper column in your chart.


Please go through the posted link , and let us know whether it appeals to you.


Narayan
 
I have just read through it, and although it seems nice, it's not exactly what I'm looking for. Problem is that, just like the line charts on which they're based (second example on the website posted), they can only show the performance of one option. This would still require me to have one chart for each (of six) options.


However, when writing this reply, another idea pops to mind. Let's see if that works!
 
You must log in or register to reply here.
Back
Top