Hi,

If your chart is on a worksheet you don't need to use VBA at all.
Make use of conditional formatting instead. Position the chart over a
cell or range of cells. Then format the chart area to have no fill. This
will make the chart transparent such that when the chart is not active
the cells beneath are visible. Then when CF is applied any colour will
show through.

Cheers
Andy