Forum Discussion

rfway's avatar
rfway
Helper I
9 years ago
Solved

data colors

I am wanting to do a line graph of 180 companies, and want 179 of those to be black and my company to be red..is there an easy way to change all the colors at once?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi rfway,

     

    I'd like to share you a simple way to achieve your requirement.

     

    Add a calculate column:

    Type = if(LASTNONBLANK(Sheet1[User],[User])="User1","My Company","Other")

     

    Drag this calculate column to legend and modify data color.

     

    Regards,

    Xiaoxin Sheng