Page 1 of 1

[Video Tutorial] - Dashboard with Real Time Live Web Data

PostPosted:Tue May 02, 2017 6:22 am
by DashboardWidgets
We took a few moments to make a short YouTube tutorial describing how to make a dashboard in Microsoft Excel that show live weather data that is pulled from the internet using our new circular dial widget.

The video covers copying, pasting, setting up the dashboard, ungrouping and configuring widgets in addition to modifying the underlying shapes using the selection pane window. If there's anything that is not clear in the video, feel free to ask more questions.


(27.38 KiB) Downloaded 2041 times
The unlocked version of this widget can be downloaded from the "Commercial License Holder's Download Area" here...
http://www.exceldashboardwidgets.com/ph ... 1280#p1280

Hope this helps and please feel free to get back to us if anything is not clear or you have more questions.

Warmest regards

DashboardWidgets

Re: [Video Tutorial] - Dashboard with Real Time Live Web Dat

PostPosted:Fri May 05, 2017 6:26 am
by sandra
When I use the type2 circular Dial widget the colors gets a different format. Could you please explain how to re-set the color to the original format?

Re: [Video Tutorial] - Dashboard with Real Time Live Web Dat

PostPosted:Fri May 05, 2017 9:10 am
by DashboardWidgets
Hey Sandra

Surprised to hear the dial is changing color.

What version of Excel are you running? You should be able to find this under FILE > HELP.

We used to work with Excel 2007 but are currently with Excel 2010 which copies and pastes widgets fine. We are aware that 2007 had a few idiosyncrasies when copying and pasting textboxes (resetting the font format to default) which always required an extra step of updating the formatting.

By the way, changing the colors back is very simple as the circular dial widget is made from simple common Excel objects that are highly configurable. You can see the objects via the selection pane (HOME > FIND AND SELECT > SELECTION PANE). Take a look at the video here..

http://www.exceldashboardwidgets.com/ph ... &t=67#p639

Thanks in advance for the reply. If you need, we can make a small video for copying and pasting using the same version of Excel that you are currently using.

Cheers

DashboardWidgets

Re: [Video Tutorial] - Dashboard with Real Time Live Web Dat

PostPosted:Fri May 05, 2017 11:54 pm
by sandra
Hello,

Thank you I managed to change the formats. Thanks again. So can I use the widget at work to create reports? does the payment is one time payment right?

Re: [Video Tutorial] - Dashboard with Real Time Live Web Dat

PostPosted:Sat May 06, 2017 2:51 am
by DashboardWidgets
Hi Sandra

Glad you managed to solve the problem!

Yes, the Commercial License is a one-time payment for ever! It also gives you free access to the Commercial License Holder's download area which means that you can also access new widgets as we develop them - for example this one (which we'll probably upload later today).
Gender Widget.png
Gender Widget.png (67.23 KiB) Viewed 98734 times
As always - feel free to keep asking for any support that you may need with using and configuring these widgets. Also, don't forget you can also subscribe to our YouTube Channel to get alerts when we upload new videos tutorials.

Good luck with your dashboard projects.

Cheers

DashboardWidgets