Forum Discussion

Mayank Agrawal's avatar
Mayank Agrawal
Copper Contributor
Feb 12, 2018

Help needed to create a particular visualization of data

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. 

Charts & Visualizing Data
Requests

4 Replies

  • Mehdi HAMMADI's avatar
    Mehdi HAMMADI
    Brass Contributor
    Feb 19, 2018

    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

    "

      • Mayank Agrawal's avatar
        Mayank Agrawal
        Copper Contributor
        Feb 19, 2018
        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.