Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Spider Chart Step1

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Back To Excel Model Analyzer Start & Demos

Spider 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 & Demos

Model Analyzer for Excel Secure Payment Options

Special! Free Choice of Complete Excel Training Course AND Excel Add-ins Collection on all purchases of Model Analyzer for Excel

1 Personal License $139.95 USD
2 - 5 Personal Licenses $118.95 USD
6 - 10 Personal Licenses $104.95 USD
11+ Personal Licenses $69.95 USD

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