Creating Dynamic Dashboards

[Former Member]

Hi,

I have Xcelsius professional 4.5 and i'm trying to create a dynamic dashboard that will update a graph and numeric cell. Basically i'm stuck because i can't work out how to link the radio buttons to formulas that will update the graphs and cells. Can anyone help?!!!

regards

Norm

[Former Member]

Hi Norm,

1. Make a hardcoded table in the excel with radiobutton id and formula as columns

2..When you click on the radio button update an empty cell in the excel with its id,

3. create a combobox pointing Selected Item property to the cell where the radiobutton updates its value.

4. Map the hardcoded table created in step 1 to the Combobox source data and map the Destination to any empty cells(1 row 2 column)(Destination cell of Combobox will have 2 columns 1-selected Radiobutton id, 2 - Formula)

5. Now map the destination cell for Formula of the Combobox to the Graph and cells you need.

Now you can get the formula you wished according to radiobutton selected.

Thanks and Best Regards

K S Sriram