ExcelDashboardWidgets

[edwin.zambrano]

I have almost successfully created a radar widget but the radar chart is all at maximum. My values range from 65 to 304, which not in the same magnitude as your sample radar widget. Not sure if I need to change any default values in the PINK cells in the My Calculations tab to cater to the bigger values.

Attached is a copy my Widget, Configuration and Calculation.

Thank you.

Edwin Zambrano
efz.thecorneroffice@gmail.com

[DashboardWidgets]

Hi Edwin

Sorry for the delay - we are currently on vacation time (in fact my kids go back to school in a few days).

If it helps, the radar widget has been designed with 10 rings to take a scoring value from 1 to 10.

The problems is that all of your values are greater than 10 so the radar maxes out.

The easiest way to make the visualization work is to use the calculations tab to automatically convert all of your values to a value between 1 and 10.

We have attached a modified version of your example.

Regards

DashboardWidgets