Format Data Color Automatically

[denz]

I am trying to automatically format the line color in a line graph automatically. For example:

If the line is for dogs then the color is blue but if its for cats then the color of the line is orange.

Is it possible to do this?

Thanks

[v-luwang-msft · Accepted solution]

Hi @denz ,

Sample base table:

visual:

You could ajust color as the below:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[ebeery]

Hi @denz, could you provide some screenshots and/or sample data to further clarify what exactly you mean here?

Do you have multiple lines/series' in your line graph or just one?  Has the data column containing (cats, dogs, etc.) been added to the "Legend" field well?