Create a chart in excel to summaries the table of contents

  • I am trying to create a chart (any type) that summarizes the table attached below. So for each topic there are X,Y,Z resources depicting their proficiency levels Expert, intermediate and so on. So If we input a level say Expert to a resource X must hold 50 points for that resource and sum up and if it falls between 85-99 then it must be colored green in the chart and the criteria is given in the attached spreadsheet.

    Can we have have all the topics in a chart where we can filter per resource and proficiency levels

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!