Help needed to create a particular visualization of data

[Mayank Agrawal]

Hello everyone,
Can somebody help me in creating a visualisation as shown in the image below. I have all the required data with me for a different parameter. Need it for a college project. 

[#2]

Hi Mayank,

First, there is no default chart in Excel to get that result. However, it is possible to built it peace by peace.

For that, you have to create two charts, a "Scatter chart" for the 'Overall Performance Index' and a "Bar chart" for the 'Incremental Change'.

Creating the bar chart is easy but you  will need some customizing for the Scatter chart and for that please read this post "

http://excelgraphs.blogspot.com/2013/03/xy-start-and-end-type-plot.html

"

[#3]

Please have a look to the attached file, you will find a solution

[#4]

Hi Mehdi,
Thanks a lot for your reply.
I somehow figured how to do it but i don't know how to combine the 2 graphs (Start-End and Bar Plot)
Can you help me with that ?
Thanks in advance.

[#5]

Hi Mayank,

No way to combine, just put the two charts one behind the second. You can also group the two objects (charts areas).