Change colour of line in ggplot2 in R based on a category

i have the following data frame in R

auto adjust in the middle text in bar in ggplot2 in R

i have a data frame called df :

Reorder the axis in ggplot2 bar based on a vector in R

I have a data frame called complete1