4 Replies Latest reply on Sep 26, 2016 4:59 AM by Nicholas Hara

    Connecting two data points with a line

    Dwight Specht

      I am analyzing survey results and want to create a chart (bar or bubble) where a value in one dimension is overlaid against the same value filtered on another dimension, but the two markers are connected by a line.

       

      Specifically, I am measuring a satisfaction score where I differentiate the survey respondent as either a leader or associate. The difference between a leaders score and an associate score along a dimension (say, Strategy) represents the disconnect between the two groups.

       

      Below is a creative mockup of the output:

       

      Here's what I did with bubble charts:

       

      what I'd like to figure out is how to connect the two scores with a line showing the disconnect value.  Kind of like the below:

       

      Thanks in advance for any ideas.