Create interactive dot plot charts with this simple trick allows you to highlight a single series and make it interactive.
🔻 DOWNLOAD EXCEL FILE HERE (includes Macro to format dots): [ Ссылка ]
🎓 LEARN MORE in my Excel courses: [ Ссылка ]
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: [ Ссылка ]
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: [ Ссылка ]
⏲ TIMESTAMPS
0:00 Introduction
0:49 The Trick!
1:04 The Data
1:21 The Base Chart
3:30 The Highlight Chart
4:47 The Slicer
5:17 Data for Highlight Chart
8:00 Formatting
9:56 Preventing Multiple Selections
![](https://i.ytimg.com/vi/ktDJil7IhWo/maxresdefault.jpg)