6 Replies Latest reply on Feb 13, 2019 11:41 AM by Paul Albert

    Single chart to show results from multiple regression correlations

    Paul Albert

      Hi All,

       

      I've been hitting my head against the monitor trying to make this work. 

       

      I am doing a presentation where I want to discuss the correlation of one measure against multiple other measures.  I've represented the problem in the attached workbook using Superstore.

       

      Rather than showing correlations individually (Comparison Dashboard) and then manually going to the trend line to show correlation measures, I'd like to develop a single chart that allows me to compare the correlation measures with each other (Desired Outcome).  So far, all I've done is spin my wheels.

       

      Any advice would be greatly appreciated.  Thanks so much!

       

      - Paul