Scatterplot chart (matrix) with conditional format

The usual starting point for conditional formatting of charts is this: https://peltiertech.com/conditional-...-excel-charts/ Would it be acceptable to implement something like that in your sheet?

Can you explain why not? I don't see anything that would prevent you from adding data labels to each data series or some other strategy for adding data labels.

I cannot, because my older version of Excel (assuming you have upgraded to something way newer than the Excel 2003 currently shown in your profile) does not support using "values from cells" as data labels. Your current setup uses 4 data series, a single point for each data series, and a single data label (value from corresponding cell in column A) for that point. Using Peltier's approach, you will end up with a chart with 3 data series (multiple points or NA() values in each data series) from 3 helper columns that pulls from the original data based on involvement. Once you have set up the three data series as outlined in Peltier's tutorial, adding data labels with values from cells should be as easy as selecting each data series, adding the data labels, and specifying column A as the source for the data label text. Can I assume, since you've already added data labels in the current file that you are already familiar with how to add data labels to a data series?

MS documentation on how to set data label value from cells
https://support.microsoft.com/en-us/...2-f467c9f4eb2d

I am unfamilliar with macro's. Is this the only way?

Peltier's approach to this doesn't use any macros, so, no, macros are not the only way. Often it is really a personal preference of programming language. If you don't like using VBA, go back to Peltier's tutorial, set up your three helper columns, point your chart to those three columns, then apply data labels to the three data series. If you have trouble with any of those steps, let us know where you are stuck and we'll help.

I am unable to imagine what you have done that causes a data label in the chart to not accurately reflect the text of the cell the data label points to. Could you upload your latest file with your chart so we can see what you've done?