I am struggling to get the below code to find a match between the Chart Series name & a selected Range cell text, but only when both are driven by equations. If no equations are used (and text only is used in the colour cells) it works fine. Any ideas why this may be the case?
Also attaching a simplified worksheet to illustrate the problem. If you click the 'Refresh' button above the chart on the second worksheet then nothing happens. But replace the equations in the Colour table with plain text (A, B, C etc...) then hit refresh and all will work just fine!! Thanks for any help!
Bookmarks