Home Page Knowledge Base Support Forum Free Downloads

Adjust panel sections size to refect scale values

Post any problems or questions you have with the ExcelDashboardWidgets spreadsheets here.

Moderator: DashboardWidgets

Adjust panel sections size to refect scale values

Postby DFD484 » Fri Feb 27, 2015 9:02 pm

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?
Attachments
ME Try 4 Widget.xlsx
(156.79 KiB) Downloaded 215 times
DFD484
 
Posts: 3
Joined: Thu Dec 11, 2014 5:56 pm

Re: Adjust panel sections size to refect scale values

Postby DashboardWidgets » Fri Feb 27, 2015 10:11 pm

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.

PWI2.jpg

Feel free to take a look at the updated dashboard attached below.

ME Try 4 Widget - Even Scale.xlsx
(156.78 KiB) Downloaded 214 times

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
DashboardWidgets
 
Posts: 332
Joined: Mon May 30, 2011 7:06 pm

Re: Adjust panel sections size to refect scale values

Postby DFD484 » Sat Feb 28, 2015 7:14 pm

Thank you for your response.
Which are the non-linear models?
Suggestions?
DFD484
 
Posts: 3
Joined: Thu Dec 11, 2014 5:56 pm

Re: Adjust panel sections size to refect scale values

Postby DashboardWidgets » Mon Mar 02, 2015 3:46 pm

Hi DFD484

Take a look at the 4th widget - "Non-Linear Dial" on the "Widgets Showcase" tab.

NL-Dial.png
NL-Dial.png (34.67 KiB) Viewed 4695 times

If you have any problems feel free to get back to us.

Cheers

DashboardWidgets
DashboardWidgets
 
Posts: 332
Joined: Mon May 30, 2011 7:06 pm

Re: Adjust panel sections size to refect scale values

Postby DFD484 » Thu Mar 05, 2015 3:09 pm

Thx again
DFD484
 
Posts: 3
Joined: Thu Dec 11, 2014 5:56 pm


Return to 3. Help! I Have a Problem, Can Someone Give me a Hand?



Who is online

Users browsing this forum: No registered users and 2 guests

cron