Visual Analysis of Data (add level)
Hello,
This is not really an issue but a feature request to add to the charts under trend line to data category. The level of the chart is the mean level line for a series of measures drawn horizontally. This type of visual analysis provides an easy to see summary of the average performance within a condition.
The chart below illustrates classroom participation under baseline, rewards, rewards removed, and return to rewards condition. The horizontal line drawn across the data path adds a visual aid to interpret the data.
The current workaround to draw the level consist of creating:
- a new serie(s),
- selecting the data range for X and Y axis that contains the average summary (e.g., baseline session 1 & 5 have average = 1.4)
- removing the markers from the data points
- selecting skip invalid data to draw the line between the two data points.
Added the workbook below with the sample data. Visual_Analysis_of_Data.gnumeric