Graph with custom grouping

Hi, I have a requirement to create a graph with the following.

Active in Oracle  - 1(ID) - count 2

Active in mainframes - 2(ID) - count 3

Pending - 3(ID) - count 4

Cancelled - 4(ID) - count 7

Now I need to create a graph with Active, Pending, Cancelled in X axis and in 5 ,4, and 7 in graph. Basically need to group 2 status in one and show the sum of count.

And then on drilldown we need to show the records associated with them in grid.

How can I achieve this.

Thanks