I am using Excel 2010 on Windows 7. Looking to see if anyone knows a way to display Data Bars in cells containing Text.
I have Project Names in Column A - and six Tasks to be completed (Columns B-G).
(1) I'd like to have the cells in Column A show a Data Bar based on the number of Tasks complete. It's easy to show a Data Bar by counting the completed cells and putting a Numeric Value in Column A - but I'd like to retain the text for the Project Name and have the Data Bar show in the same cell.
(2) If one of the Projects has a Task which is "At Risk" I'd like to have the Data Bar for that Project to show in Red. Assuming all other Projects are completing their Tasks - the Data Bars for those would be Green. Not sure if this is possible to do...?
The attached screenshot shows what I'm working with.
I have Project Names in Column A - and six Tasks to be completed (Columns B-G).
(1) I'd like to have the cells in Column A show a Data Bar based on the number of Tasks complete. It's easy to show a Data Bar by counting the completed cells and putting a Numeric Value in Column A - but I'd like to retain the text for the Project Name and have the Data Bar show in the same cell.
(2) If one of the Projects has a Task which is "At Risk" I'd like to have the Data Bar for that Project to show in Red. Assuming all other Projects are completing their Tasks - the Data Bars for those would be Green. Not sure if this is possible to do...?
The attached screenshot shows what I'm working with.