Chart

Enma

I have a project manager that am working with, and have status, %completed, assigned to-- I want to create a chart in the dashboard that gives me the %completed by assigned to, this way I can see how much they have completed…is there a way to do that? thank you in advance! Enma

JR90

If you want something like this ↓

You would want to set it up like this in a helper sheet or helper columns (and hide the columns)

Paul Newcome

You can create a row report, bring in the assigned to and % complete columns, group by assigned to then use the summarize feature to average the % complete and use this report to populate your chart.

This will automatically add new people to the chart as they are added to your project plan, is (usually) easier to set up than formulas with cross sheet references, and has the ability to scale by simply adding more project plans to the report scope as/if needed.