ExcelDashboardWidgets

I have created a linear dial widget and I need the section panels for the scales to be more reflective of the values. For example:
When I enter 46.00 as the needle value, it reads 46.00 but points to an area about the 60.00 value area on the section panels and not where it should point.
Is there a way to make the section panels more reflective of the actual values?

Hi DFD484

We took a quick look at your dashboard. The dial is actually pointing to the correct position. However your scale intervals are all unequal.

The main reason for this is that you have not copied and pasted the scale calculation cells on the "my calculations tab" (cells D22 to D26 have formulas in them). For example, the formula automatically divides the scale interval of 100.80 by 5 to give 20.2.
Feel free to take a look at the updated dashboard attached below.
Perhaps you were looking for the non-linear dial - which allows a non-linear scale and may better serve your needs)?

Feel free to get back in touch if there is anything that is not clear or you require further assistance.

Hope this helps!

Cheers

DashboardWidgets

Thank you for your response.
Which are the non-linear models?
Suggestions?

Hi DFD484

Take a look at the 4th widget - "Non-Linear Dial" on the "Widgets Showcase" tab.
If you have any problems feel free to get back to us.

Cheers

DashboardWidgets

Thx again