8 Replies Latest reply on Aug 30, 2011 8:32 AM by Catherine Peloquin

    Easy way to have multiple measures + calculated reference lines on same chart?

    Catherine Peloquin

      Hello,

       

      I have data from a survey that was done two years in a row.

       

      The data is of the form:

      Year Participant_ID Q1_Answer Q2_Answer Q3_Answer .....

       

      What I want to do is create a bar chart of this year's average response to the questions, with a reference line that indicates last year's average.

       

      The trick: I want to be able to show multiple related questions as the bars on a single chart.

       

      Is there a way to accomplish this without creating a ton of calculated fields? I have >75 survey questions, so simple is best.

       

      I have browsed the forums here and seen examples of a bar chart + reference line for 1 measure, but what I am trying to do complicates things.

       

      Thank you very much for your assistance,

      Kate