Is there a way to override a series based on the value of a column being returned

I’m currently charting some data the metric is a price. The data consists of many different types that I would like to display in different point colours.

Currently I cannot see a way to do this other than to split this into multiple queries isolating the different types in each. This seems inefficient as this is multiple queries.

Is there a better way to do this? If so how?