Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Bar Chart - used for a Tornado Chart
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Bar Chart - used for a Tornado Chart
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" wrote in message oups.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D column chart, stacked | Charts and Charting in Excel | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Stacked Chart help needed | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
How to make a stacked bar chart using time? | Charts and Charting in Excel |