I have a small Excel-dataset where I present projects and their priority in a X-Y-diagram. The dimension is the name of the projects, and X,Y (and Z) are the priority variables. This gives data Points with different colours, but I would like to set the colours so that they represent clients. i.e. all green dots belongs to client A, all red ones to client B, etc.
My Excel columns:
1. Name of project (dimension)
2. X-variable
3. Y-variable
4. Z-variable
5. Clients
The actual colour choice is of no importance; the important thing is that the maintenance level is low, so that the project list can be continued freely without updating data anywhere else. Is there a smart and easy way to this? Preferably without any mapping of colour tables.
