Hi All,
I need some help to create a stacked column chart to show the risk count (high, medium and low) for projects grouped by programme. I've attached a sample sheet to explain what I am exactly trying to do. I have created pivot from master data to represent the count of high, medium and low risk. The first pivot under "Chart 1" tab is the count of risk grouped by programme only. It's simple to do and the chart is also coming properly. But I want to show the project numbers on each column in a stacked manner. When I included the project numbers into the pivot (second table) the chart got messed up. The chart that I want to create should look like the one on the "Chart 2" tab (it's just an image edited on MS paint). Is there any way that can create a chart like that image.
I hope I've explained what I'm trying to achieve. If not, please let me know. I'll explain further.
Bookmarks