+91-8826547882

Movie Rating Dashboard

Hello Friends,

Let’s talk about dashboard designing today.

Last weekend I was planning to watch “Mission: Impossible – Rouge Nation” and I started searching for the movie reviews on google as you all do 🙂 . And while reviewing, thought came into my mind to create the dashboard for the same.

3 Star Conditional Formatting

So here we go with our movie rating dashboard.

Dashboard have “5 Star Reviews” column and other details like star cast, release date and critics/readers rating.

PS: Movie is super kool, I liked it.

Here you can download the Dashboard Template.

You can use the same template to design other dashboards like Sales Dashboard for Customer Satisfaction Ratings.

What is Dashboard?

Dashboard is a graphically representation in the form of charts and tables which initiate us to take action.

How to make it?

I have used below functionality in the dashboard.

  •  Database created with fields(Movie Posters(Image), Release date, Critics/Readers rating and Star Cast)
  •  Icon Sets Conditional Formatting (3 Star Rating)
  • Updated movie poster ranges in the dashboard as Name Range
  • “Worksheet_SelectionChange” Event.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error Resume Next
If Not Intersect(Target, Sheet1.Range("B7:B37")) Is Nothing Then

    Sheet1.Range("O8").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 2, 0)
    Sheet1.Range("M8").Value = Target.Value
    Sheet1.Range("M10").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 4, 0)
    Sheet1.Range("M12").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 5, 0)
    Sheet1.Range("M14").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 6, 0)
    Sheet1.Range("M16").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 7, 0)

End If

End Sub
May 24, 2016

0 Responses on Movie Rating Dashboard"

Leave a Message

Your email address will not be published. Required fields are marked *

© copyright www.excelcrazy.com. All rights reserved. Design and Development by www.creativebrainweb.com

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Location (required)

Your Message for us...

captcha