Page 1 of 1

Needle showing three lines

PostPosted:Mon Feb 05, 2018 1:22 am
by pmhaps
My needle shape is replaced by 3 lines. Can any body help to get the original shape? What type of XY graph is required to have original needle shape?

Re: Needle showing three lines

PostPosted:Mon Feb 05, 2018 1:55 am
by DashboardWidgets
Hi pmhaps

The needle of the dial widget is actually made up of three lines to form a long, thin triangle (the needle).

When these lines are given a thickness of 7pt the three lines are rendered into a needle shape.

The widget calculations sheet performs the mathematics to transform a value (e.g. 25 out of 100) into an angle (i.e. 45 degrees) which calculates the X-Y graph for the needle.

Hope this makes sense and feel free to post a screen capture or mobile phone photo of your problem.

By the way, which version of Excel are you using?

Cheers

DashboardWidgets

Re: Needle showing three lines

PostPosted:Mon Feb 05, 2018 10:18 am
by pmhaps
Go east or west "DashboardWidgets" is the best. Problem solved. Thanks.