Cannot change entries in spreadsheet part 2

Here are formula modifications to G15:G17 respectively on the dashboard sheet:

Formula:

=COUNTIF('2.Corp Escalation Risk Log'!L6:L57, "<="&6)

Formula:

=COUNTIFS('2.Corp Escalation Risk Log'!L6:L57, ">="&8,'2.Corp Escalation Risk Log'!L6:L57, "<="&15)

Formula:

=COUNTIFS('2.Corp Escalation Risk Log'!L6:L57, ">="&16,'2.Corp Escalation Risk Log'!L6:L57, "<="&25)

Following these modifications as a template you could complete the Target and Current Risk Rating tables.
I don't see the problem with the Issue Type series on the Corporate Risk & AOR/Issue types chart, however the Risk Type series is trying to reference a group of cells that, while hidden by the chart, are blank.
I changed the formula for the AOR/Issue types table, cell D21 to read:

Formula:

=COUNTIF('4.AOR-Issue Log'!C$6:C$62, C21)

I made some changes to the series in the other graphs that will hopefully work once the formulas in Target and Current Risk Rating tables are corrected.
Let us know if you have any questions.

instead of posting pics - which many members cannot see, upload a sample workbook please

I think that I have gotten all the table and chart formulas linked to the correct sheets and columns. The only things I am hesitant about are the three risk rating tables in columns C and D. The formulas all referenced the '2.Corp Escalation Risk Log' sheet column I and the values in those cells aren't numeric, so I doubt that is correct.
Let us know if you have any questions.

To solve the #N/A issue on tab 4 I wrapped those formulas inside the IFERROR function, and then removed IFERROR from the risk rating column so the #N/A displays there.
Take a look and see if I have the tables and charts linked correctly.

The graph colors correspond to the table from which the values are taken i.e. initial, target or current. You can double click on any of the columns in the graph to bring up a window in which you can change the fill color.
Change the array entered formula in cell L2 of tab 2 to read:

Formula:

=IFERROR(INDEX('3.Risk Codes'!$C$52:$G$56,MATCH(H6,LEFT('3.Risk Codes'!$B$52:$B$56,1),0),MATCH(K6,'3.Risk Codes'!$C$50:$G$50,0)),"N/A")

Remember to simultaneously press Ctrl, Shift and Enter after the changes have been made. You can then double click the fill handle to have the formula copied down the column. Make the same change for all columns headed 'Risk Rating'.
Let us know if you have any questions.

I changed the formulas on tabs 2 and 4. If you want the column colors changed you'll need to tell me what color you want to use for initial, for target and for current.

Chart colors assigned. Let us know if you have any questions.

So that you'll know how to do this in the future, with H6 (on tab 2) selected, find and select Data Validation on the Data tab and change the values in the in the source window. I also changed the formula in H6 (tab 2) to read similarly to the formula in H12 on tab 4:

Formula:

=IFERROR(LOOKUP(H6,'3.Risk Codes'!$B$21:$C$25),"")

Let us know if you have any questions.

Column A of table 5 needed to be changed from "A (certain)" etc. to "1 (certain)" etc. The array entered formulas for the risk ratings needed changing so that they would find the values of the text recovered by the LEFT function from column A of table 5. They now read:

Formula:

=IFERROR(INDEX('3.Risk Codes'!$C$52:$G$56,MATCH(H6,VALUE(LEFT('3.Risk Codes'!$B$52:$B$56,1)),0),MATCH(J6,'3.Risk Codes'!$C$51:$G$51,0)),"N/A")

Let us know if you have any questions.

That being the case it would appear that instead of changing the values in column A of table 5 from A,B,C... to 1,2,3... (as in the file attached to post #22) they instead need to be changed them from A,B,C... to 5,4,3... Making that change yields the values stated in post #23
Let me know if you if you need to see my updated copy of the file.

Here is the amended workbook with the conditional formatting rules applied.
Let us know if you have any questions.

I really can't tell you why the LOOKUP based formulas stopped working, however when replaced with VLOOKUP based formulas, as follows, they provide the expected results:

Formula:

=IFERROR(VLOOKUP(H12,'3.Risk Codes'!$B$21:$C$25,2,0),"")

Let us know if you have any questions.

I am doing well thanks, and hope that you are also.
I think that those issues are sorted out.
To get the axis labels I put them in cells H65:J65 on tab 4 then edited the chart axis to reference those three cells.
To get the table to sort and allow the chart to still work I had to do two things:
1) remove the merge and center in row 64 (of tab 4) and replace that with alignment across selection from the Number pane on the Home tab.
2) resize the table so that it only extends through row 63, otherwise when you sort a column (i.e. column L) either A to Z or Z to A row 64 gets moved and the values that create the columns on the chart are tied to the values in row 64.
Let us know if you have any questions.

I'm not certain what "also when i sort it seems to put the smallest value at the top when i choose a to z" means. Sorting a to z means to put in smallest to largest order. As for the sort z to a issues, I assume that you mean that all of the N/A's are placed above the numeric values. My suggestion would be to filter those out when the z to a sort is in effect, you can always filter them back in when the sort a to z is applied. On these topics, Sorting and Filtering, I don't have as much experience as on other topics. It might be best to open a new thread addressing those questions in the 'Excel General' forum with the terms 'sort' and 'filter' included in the title to draw attention from members who have more experience with those topics.
Let us know if you have any questions.

Seems that is the protocol when that range of cells, $H$11:$V$63, becomes a Table. When I changed it back to a range I was able to delete the numbers, however as soon as I put the range back into a table format the numbers reappeared. That is a question that you may want to ask a broader audience to address.