Highlight Chart Values on Drop Down Selection - Excel Chart Tricks

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; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us!