Excel Crazy

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
September 23, 2017

0 responses on "Movie Rating Dashboard"

Leave a Message

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


© LOKESH PALIWAL 1987 - 2018


Reporting Solutions | Data Consulting | Analytics Training

close slider

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Message for us...

Skip to toolbar