Suggestions for Chart / Graph

I have three sets of data that I am trying to figure out how best to show. Basically, there are three columns. The first column is the number of Submissions, the second column is based on those submissions, how many were accepted, the final is based on those submissions how many were declined

Submissions: 20
Accepted: 5
Declined: 15

What I am trying to figure out is how to best show this data within a chart, where we can actually show this data in a graphical way. Any suggestions on the type of chart/graph that would best communicate this information?

You have a number of alternatives but I think a stacked bar would work pretty well. See the attached spreadsheet.

You might prefer a stacked column or another option would be 100% stacks. With the 100% stacks you'd have to state the total number of submissions but it would show the comparison of acceptances to declines more clearly.

BTW - I've added the variable to time period in the attached just to show you how these bars can be used to show comparisons. You might not have time periods in which case you can use people, topics or something else (or nothing).

Stacked bar, 032113.xlsx

Hello,

I would suggest you for a sub-divided bar chart as shown in the attached excel which could show accepted and declined proportion.

Also if you want to compare for each month we could use Pie chart as well.

Please find the details in attached spreadsheet. Let me know if you need any further assistance.

Thanks
Harini.S