Show Percentage from Sheet as Pie Chart in Dashboard
I have a user on my team who is looking to show progress made against major tasks in his sheet as individual pie charts on a dashboard. For example, if "Milestone 1" is 50% complete, he'd like a pie chart on the dashboard that's just half filled in. Some of these tasks will just have an estimated percentage filled in, so they may not all be calculated by rolling up sub-task completion percentages. I'm not seeing a way to display a single cell from a sheet visually in this fashion, though. Is there a workaround perhaps that I'm not thinking of that would achieve this?