I am conducting a program evaluation, tracking clients' progress in various
Categories as a result of their participation in a program. In each Category
a client may be deemed In Crisis, At Risk, Stable, Safe, or Thriving (I'll
call these Series). There are Y possibilities in each Series. (Each Series
might have a different value for Y.)

The client responds to a questionnaire by marking responses in various
components of each category. The responses are cataloged by me on a Matrix
broken down by Category and Series.

I want to track these responses on a chart (I'm thinking a bar style),
reflecting the percentage of each positive response per Series. Is it
possible to do this without having an additional column for the formula?

Series1 Max Series 2 Max Series 3 Max
Category1 X Y X Y X Y

Question clear as mud?