Forum Discussion
walkie74
Nov 12, 2019Copper Contributor
Creating a tracker for monthly and random items
Hi folks, I've been asked to track a number of items, some monthly and some at random. Ideally, this would be in Excel. I'm not sure how to create a tracker like this, though. Any suggestions?
walkie74
Nov 20, 2019Copper Contributor
OK, so I added some data to the tracker you sent me. And I've got a couple of questions:
1. I can figure out how to filter the data (thanks to the filter button), but how do I display the data graphically, like in a pie chart? All I need is to be able to differentiate between priorities, and to show a percentage of work completed.
2. How do I change the values of the completion status? I keep getting an error message saying that "A user has restricted values that can be entered into this cell."
3. I've noticed that the title and Priority will autofill with the SOP#, but the other fields won't. Not sure why that is.
walkie74
Nov 20, 2019Copper Contributor
Oh, and I forgot this...