ExcelDashboardWidgets

Helping you create stunning dashboards in Microsoft Excel including dials, speedometers, thermometers, and much more...

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

Moderator: DashboardWidgets

By Gavintaylor
#1245
Hi,
And thanks for helping me.
I have attached my dashboard with the particular widgets I need. I have started on the first one, as you can see in the spreadsheet and have managed to link it all except for the needle reading the correct value.
Two things are confusing me. First I watched the tutorial U tube video where Brian explains how to link the widgets. This is fine except where he copies the My calculations block from the master the portion he copies does not look like the block that has been supplied on he master you sent after I purchased the license. Is this now updated and if so please explain exactly what to copy.
Second in the tutorial I can understand that the need X and Y values need to be changed to the correct tab and cells. I have done this but it must be wrong as the needle is still incorrect. Can you please check what I have done wrong. Also I can see how the X and Y values are changed but also in the string of the formula Brian changes another vale at the start of the string but it is not explained so I do not understand. It is right at the section where he says in the video "And now the needle moves to the correct value. this is about a minute before the end of the video.

Sorry for being so slow on the uptake
Regards
Gavin
User avatar
By DashboardWidgets
#1246
Hi Gavin

We prepared a small video which should help you out.



If you have more questions, please feel free to get in touch.

Cheers

DashboardWidgets

Download and try for free!