HOME Excel  | Software | Excel Formulas | Excel Macros | Free Excel Help | Excel Training | Excel Development | Newsletter | SEARCH | Contact Us


Tornado Chart Step 1

Back To Excel Model Analyzer Start

Tornado step 1
 

 

 

 
In your model, choose the Output to be analyzed. The add-in automatically recognizes Output
row and column headings. To clear column heading from the chart, uncheck the the Column checkbox.
In this example, the row heading is Retained Profit for the Year and the column heading is Dec-06.

There are two ways of choosing Input variables:

1. Check the Track Inputs checkbox and the add-in will automatically find the inputs associated
to the selected Output. Indicate if you want to show row and column headings of such imputs.

Click the Next button to list the inputs found. Select the inputs you will work with from
the list. In this example, the list would be:
 



 
2.Uncheck the Track Inputs checkbox to manually choose the input variables. Click Next and
a dialog will pop up. Use the Cells box in the dialog to choose the range containing the inputs.

The Figure below exemplifies this:
 


 

Back To Excel Model Analyzer Start

Software Categories Search Software

Excel Add-ins || Excel Training || Excel Templates || Employee Scheduling Software || Excel Password Recovery and Access & Word etc|| Excel Recovery and Access & Word etc || Financial Software || Financial Calculators || Conversion Software || Construction Estimating Software || Drilling Software || Real Estate Investment Software || Time Management Software || Database Software || Neural Network Software || Trading Software || Charting Software || Windows & Internet Software || Barcodes Fonts, ActiveX, Labels and DLL's || Code Printing Software || Outlook Add-ins

MOST POPULAR! Excel to HTML

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us