Hi,
I have a Requirement List with Requirement title, Client , Project, Priority and date created as columns.
Priority is a Choice column with RED/AMBER/GREEN choices.
I want to create a pie chart out of this list showing RED/AMBER/GREEN slices.
I tried using chart webpart. One thing is my Y axis is always Date created column and I don't have option to change. Also I tried selecting Requirement title as X axis and grouped by Priority. But I am not getting the desired graph.
What needs to be done? Am I missing anything?