Forum Discussion
Pie charts/graphs with embedded IF functions for risk and issue register
PW0105 Very likely that it is possible, but it would help if you could upload your file (without any confidential info in it). Then, it will be much easier to grasp what you are trying to achieve.
Riny_van_Eekelen see attached
- Riny_van_EekelenAug 18, 2020Platinum Contributor
PW0105 Have a look at the pivot_table tab in the attached sheet. Is that what you had in mind? I created a pivot table and pivot chart from the data in the risk register. If you are not familiar with pivot tables, check this out first.
By the way, you'll see that I cleaned up the Risk Register. I'd recommend that you do not use merged cells. They totally screw up the structure of the data. Use the alignment option "Center across selection" in stead. Got rid of them, all the borders and all of the rows without a project name. Perhaps, you want to look into the use of structured tables as well. That way, you don't need to worry about updating data ranges, every time records get added.
- PW0105Aug 18, 2020Copper Contributor
Thanks soo much Riny_van_Eekelen this is exactly what I wanted to achieve, (wish I thought of that! I'm a bit of a novice when it comes to excel, but always trying to learn) I've also replicated for the issues tab - only thing is I can't get the High Medium Low in the chart legend to display in that Order - will only let me filter it A-Z or Z-A... also noted about the merged cells and I'm glad you told me that because I've encountered issues when cutting/pasting things across merged cells!
- Riny_van_EekelenAug 18, 2020Platinum Contributor
PW0105 You can select a column in the pivot table (see picture) and drag it left or right to where you want it. This over-rides the standard alphabetical sort order.