In this video, we highlight a specific value in a chart from a drop down selection.

We have a dashboard report with two top 5 tables and two charts. This is all driven drop a drop down selection.

When a cell value is selected we want the data point in the column charts to change colour to visualise that value.

For this, we will create a conditional column in the data and modify our chart to include that column.

Find more great free tutorials at;
[ Ссылка ]

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]

Connect with us!

LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]

свернуть