help with a graph

[Assamita]

Hi everyone.

I'm trying to create a graph, but I think I had a brain fart or something, cause I can't figure out how to, and I'm sure it's a very simple one.

The data I have is number of orders for 3 vendors rejected and ok, for two months. Something like:

[TABLE="width: 522"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Vendor[/TD]
[TD]Month[/TD]
[TD]Rejected[/TD]
[TD]Not rejected[/TD]
[TD]Total of orders[/TD]
[/TR]
[TR]
[TD]Vendor1[/TD]
[TD]May[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]314[/TD]
[TD="align: right"]363[/TD]
[/TR]
[TR]
[TD]Vendor2[/TD]
[TD]May[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]313[/TD]
[/TR]
[TR]
[TD]Vendro3[/TD]
[TD]May[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]Vendor1[/TD]
[TD]June[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]206[/TD]
[TD="align: right"]228[/TD]
[/TR]
[TR]
[TD]Vendor2[/TD]
[TD]June[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]168[/TD]
[TD="align: right"]187[/TD]
[/TR]
[TR]
[TD]Vendor3[/TD]
[TD]June[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]41[/TD]
[/TR]
</tbody>[/TABLE]

The graph I want to do is super simple. A pie with only two colors for "Rejected" and "Ok", and two slices to filter between vendors and months.

Can anyone help, please?

Thank you

 

[sheetspread]

You really should unpivot the data first, using:

https://www.youtube.com/watch?v=xmqTN0X-AgY

then you can set a pivot chart easily

 

[Comfy]

Reformat your data and use a Pivot Chart.

Example attached.
https://filehost.net/3f3307156fdc7139

 

[sheetspread]

(right click the chart to add data labels)

 

[Assamita]

Thank you sheetspread. Can that be done in Excel 2010?
Also, I can't download the file. Somehow, it only opens up in a browser tab, but I can't find the download button there. Do I need an account for that?

Regards

 

[Assamita]

Nevermind!! I've already figured it out. Thanks a lot!