I am using the To-Do List business template in Excel 2010 and the left handed column is a really cool progress bar that displays a percentage value and a colored progress for my task. I like this feature, but the colored progress bars for each task are all over the place and I can't make sense of them. For example, a cell that shows 25% complete has the progress bar showing through half of the cell, which indicates to me that the task is 50% complete rather than 25% complete as indicated by the percentage value in the cell.
Can someone please tell me how to correct this? If I have a cell that shows a numerical value of 10%, I'd like the colored progress bar to actually fill up 10% of the cell.
I've attached a screen shot showing the issue I'm having if you need it.
Thanks in advance.
Regards,
Dino
PS, it appears that the progress bar is considering values from a number of different cells and I want it to use only the value in the individual cell. Sill confused on how to do this.
Bookmarks