Need help to prepar a chart

Can you provide any more detail? What chart type do you want to use? What do you want the chart to communicate?

Assuming the question is specifically about hot to create a chart in Excel, I would suggest starting here: https://support.office.com/en-us/art...__toc255902075 This help file describes the basic steps to creating a chart in Excel. The first step (arrange the data in the spreadsheet) is often important, so pay attention to the suggestions made for your desired chart type.

If you still have no idea what to do, then I would suggest you select A3:I7 and insert a clustered column chart (or whatever chart type you want). Then see how closely that chart achieves what you want.

Graph.xls

please find the attach file if this kind of thing can be done.
with a picture, I have set it for only " Transaction Dependent ", if the same can be created through a chart.

also, want to add the success rate as a line chart in the same graph

Regards
Arindam

What I see in your picture is a "clustered and stacked" column chart - which is basically a stacked column chart with a "sparse" data arrangement. I would suggest that you study this tutorial http://peltiertech.com/clustered-sta...mn-bar-charts/ to understand how to arrange the data in the spreadsheet, how to add that data to the chart so that you get the "clustered and stacked" look. Then you will be in a better position to adapt those techniques to your data and chart.

Adding the "success rate" as a line chart should be straightforward after creating the stacked column chart. Like other combination charts, you will add the success rate as its own series, then change the chart type to line. Then work out the primary and secondary axis systems so that you get the desired look.

Sleep overcame me before I saw your last post. Did you figure something out?

A quick rundown of the steps to create a clustered and stacked column chart for your data:

1) First consideration, do you need the table as is? If so, create a copy of the table so you have a good presentation copy of the table, and a copy that you can manipulate and build the chart from. If you don't need a presentation copy of the table, then work on the existing copy.
2) As I noted above, the bulk of the work of creating a clustered and stacked column chart is arranging the data in the spreadsheet. You will need three rows for each "category", so insert two rows in between each existing row.
2a) Select rows 7 and 8 and insert rows (Home Tab -> Insert group -> Insert rows command). Select rows 6 and 7 and insert rows. continue until there are two blank rows in between each Role.
3) The Expected column needs to be in the first row, the expected vs actual values need to be in the second row of each group, and the current capability values need to be in the third row of each group.
3a) Select B3:B15 (the expected column values) and move them down one row (ctrl-x -> move down one row -> ctrl-v)
3b) Select E3:I15 (the current capability columns) and move them down two rows.
4) Insert Stacked column chart
4a) delete A2 (you can re enter the Roles text later after the chart is created)
4b) Select A2:I17
4c) Insert -> column chart -> Stacked column (not 100% stacked column)
5) Everything should be close to what you show except for the success rate series is one of the stacked columns. Select the success rate series -> change chart type -> line
6) Format the line series (and other series) to improve the look.

that won't be exactly what you show in your picture, but it should be close, and should be enough for a "put something together at the last minute" situation.