Excel Dashboard (Data Visualization)
This video gives you an insight into how to create a dashboard in Microsoft excel. Microsoft Excel is mostly used for data analytics, graphs & some advanced level Marcos. However, there are few people who do data visualization better than anyone.
0:00 Insert CheckBoxes in the Sheet
1:30 Link Check Boxes with cells
2:45 Utilization of Checkboxes in %?
7:57 IF Formula Copy Paste
8:45 Correction in IF Formula & calculate Overall progress
10:34 Dashboard Preparation & Graphics
18:06 Insert Meter in Dashboard
21:05 Dashboard Preparation & Graphics
VBA Code
Sub LinkCheckBoxes()
Dim chk As CheckBox
Dim lCol As Long
lCol = 1 'number of columns to the right for link
For Each chk In ActiveSheet.CheckBoxes
chk.LinkedCell = chk.TopLeftCell.Cells.Offset(1, lCol).Address
Next chk
End Sub
On this page of the site you can watch the video online Excel Dashboard (Data Visualization) with a duration of hours minute second in good quality, which was uploaded by the user Nauci me 01 January 1970, share the link with friends and acquaintances, this video has already been watched 130 times on youtube and it was liked by 7 viewers. Enjoy your viewing!
