Price change % is my column of interest. I would like to measure whether or not there are correlations between Price change % and any of the other columns. What visualisations would be best for this?
What I've tried so far is creating pivot tables and grouping by Production year, Category, Margin % and Category 2 and sorting by Price change %. I've then attempted a scatter graph by displaying the Production year on the x axis and Margin% on the y axis. Does this make any sense? Or must I have the Price change % as one of the axis? Also, I haven't been able to introduce attentional measures to the scatter graph. Would it be beneficial to do so to measure the correlation when multiple groups are combined. Eg a certain combination of Category 2 + Production year.
What MS visualisations or other tools in Excel would you recommend for me to use in order to assess correlations?