Stacked Bar Chart - used for a Tornado Chart

I've been using Excel to develop a tornado chart in a sheet I'm using.

I've used a stacked bar chart with a blanked out first bar to float the
remaining bar(s) - and this has worked fine - and I have managed to get
the chart to be able to automatically reflect scenarios where the
min/max values are both negative, positive and a positive/negative mix.

The last task that I want to do is to put a single 'line' on the chart
to indicate the baseline value of the tornado - so it runs top to
bottom through the bars.

As this is going in a model I want this to be automatic rather than
hardcoding this into the chart

Any ideas - its annoying me to death

Steve

Hi,

Do this help at all.
http://www.andypope.info/ngs/ng3.htm

Cheers
Andy

sbeard@rti.org wrote:
> I've been using Excel to develop a tornado chart in a sheet I'm using.
>
> I've used a stacked bar chart with a blanked out first bar to float the
> remaining bar(s) - and this has worked fine - and I have managed to get
> the chart to be able to automatically reflect scenarios where the
> min/max values are both negative, positive and a positive/negative mix.
>
> The last task that I want to do is to put a single 'line' on the chart
> to indicate the baseline value of the tornado - so it runs top to
> bottom through the bars.
>
> As this is going in a model I want this to be automatic rather than
> hardcoding this into the chart
>
> Any ideas - its annoying me to death
>
> Steve
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks for the reply

I've actually managed to put in the line I wanted down the average
value by reseting the y-axis to cross the x-axis at the average value
rather than the 0 default - this has worked well

So basically I've now got an in-sheet method based on 4 cell based
formula per sensitivity parameter which I then feed into a stacked bar
chart - and then I reset the y-axis crossing

This produces a nice looking Tornado plot without the need for an Excel
add-in

I'll post this as an example when I get time to tidy it up a little

Steve

Steve -

If you want to write it up, I could post it on my site as an alternative to

http://peltiertech.com/Excel/Charts/tornadochart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"stevieb" <sbeard@rti.org> wrote in message
news:1144188439.147503.249670@e56g2000cwe.googlegroups.com...
> Thanks for the reply
>
> I've actually managed to put in the line I wanted down the average
> value by reseting the y-axis to cross the x-axis at the average value
> rather than the 0 default - this has worked well
>
> So basically I've now got an in-sheet method based on 4 cell based
> formula per sensitivity parameter which I then feed into a stacked bar
> chart - and then I reset the y-axis crossing
>
> This produces a nice looking Tornado plot without the need for an Excel
> add-in
>
> I'll post this as an example when I get time to tidy it up a little
>
> Steve
>