Hi there,
Is it possible for me to create a progress bar chart based on text?
So I have a spreadsheet that has a department column and the other column I want to use the data from is a status column with 3 drop down options… is it possible for me to get a chart that shows each departments progress based on the status drop downs? I have each status colour coded to red/yellow/green so would like that to follow through to the bar chart progression… is this possible?
Many thanks for taking time to read
Hazel
Is it possible for me to create a progress bar chart based on text?
So I have a spreadsheet that has a department column and the other column I want to use the data from is a status column with 3 drop down options… is it possible for me to get a chart that shows each departments progress based on the status drop downs? I have each status colour coded to red/yellow/green so would like that to follow through to the bar chart progression… is this possible?
Many thanks for taking time to read
Hazel