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
Data

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:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 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.
https://www.pk-anexcelexpert.com