Scatter Plot with different colored points

Valued Contributor

@msm66  - here is that example file with the formulas to pull out data sets and sample scatter plot with those different series and hence different color (or other) formatting for each set of points

2 Replies
Thanks @marler
What if the value is string not int?
The "FILTER" function would still working?
Best Response confirmed by mtarler (Valued Contributor)

@msm66  absolutely.  In that attached sheet you can use any 'color vals' to group the points and then in row 1 you just enter the corresponding category number/text/name/etc... at the top of that group (E1, G1, I1) and you can create more sub-sets by copying the top 4 cells of any sub-set (e.g. D1:E2) to a new pair of columns and then copy the NAME formats in the name manager to add names for the new columns and then add the corresponding data sets onto the graph.