Spotlight Visualization
Charts and Visualization

Spotlight Visualization in Excel (Part-2)

This is the second part of Spotlight visualization. Here we have used spotlight to highlight top performer in the chart. We have created a Column Chart for Team Manager wise sales and highlighted the team manager with the highest sales.

Below is the data which we have used in this chart-

Data set

We have created this chart in 2 variants. Below is the snapshot to variant-1.

Spotlight Visualization variant-1
Spotlight Visualization variant-1


Below is the snapshot to variant-2.

Spotlight Visualization variant-2
Spotlight Visualization variant-2


Click here to download the Practice file-

Watch the step by step video tutorial:

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.