Hello! I have about 8 spreadsheets of data that I need to compile into one
chart. However, I need to be able to look at the chart and see which
spreadsheet a data point is from. Is there a quick way to color code a group
of data points from one spreadsheet? I know I could change the color
individually, but with over 50 data points, I'd rather not if I don't have
to! Thank you.