I have 6 projects. Each has a risk register on a separate sheet
Each risk has one of 5 possible statuses each of which has a color, (Blue, red, green…).
Each risk also has a Probability/Impact score, grouped by 5s, 1-25
I have created 10 sheet summary fields on each sheet to count these.
I have created a sheet summary report including all 10 fields for all 6 sheets.
The intent is to create charts for a dashboard
- to show how many risks there in each PI Category
- to show how many risks there are for each color
However when I attempt to make chart on the dashboard, it includes all the zeros when what I want is just the totals
So for example. I would like it to show, 2 for the PI< 5 column, 5 for the PI 6-10 column, 2 for the PI 11-15 column, etc.
I fiddled with the data source and axis settings but I can't get it how I want it.
(BTW Yes I know the chart name is wrong)
Do I need to start over and just create summary fields on a separate metric sheet and pull the chart data from there?
Thanks for helping,