Hi QV Community,
I am trying to create a scatter graph based on multiple fields of data, with comparisons on 2 sets of averages ranging between 0-10. Its based on a survey, requesting Importance score vs Satisfaction score across several different areas. Data is pulled from Excel as follows:
|Respondent||Imp A||Sat A||Imp B||Sat B||Imp C||Sat C|
I am looking to plot axis X as Satisfaction, Y as Importance, with the averages as the score. Is this possible in QV? What would the expressions/dimensions be?