Learn how to dynamically highlight charts.

A dynamically highlighted chart can significantly enhance the visual representation of data, making it easier to understand and interpret. By using a simple formula like “=IF(A2=$B$11,B2,””)” in combination with a few steps, you can create a chart that dynamically highlights specific data points based on certain criteria. In this tutorial, we will explore the process of adding a selection column to a chart, adjusting its appearance, and subsequently hiding it to achieve an aesthetically pleasing and informative visualization.

These are the steps outlined on the video.

Create Selection Column
1) Add Selection column
2) =IF(A2=$B$11,B2,””)
3) Apply formula to rest of the rows.

Add To Selection Column To Chart
1) Select Chart
2) Drag blue box
3) Right-click on the new bar chart (orange), and select “Format Date Series…”
4) Set Series Overlap to 100%
5) Close

Hide Selection Column
1) Highlight selection column
2) Change font colour to white

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips